Note: Only looking for C*C position .. Open to relocate anywhere in the USA & Immediate Joinee
Motivated and ambitious SQL Server Data Warehouse/Business Intelligence Developer with advanced experience in building Data Warehouses, ETL Scripts and BI Solutions using Microsoft SQL Server and BI suite of applications.
SQL Server 2000/08/R2/2012/2016 SSRS SSIS SSAS
9+ years of accomplished BI development and Data Warehouse implementation for Healthcare, Retail, Insurance and Banking industries.
Excellent Experience interacting with Business Users to analyze the business process and requirements, writing Business Requirement Documents, Technical/Functional Specification Documents, Data/Dimensional Modeling and drawing up the Process Flow charts, DFD’s and ERD’s using MS Visio and Erwin.
Experience with full development cycle of OLTP and Data Warehouse (OLAP) architectures.
Strong experience working with SQL Server using T-SQL in constructing Tables, Stored Procedure, Triggers, Views, Indexes, Relational Database Models and Data Integrity and frequently used Joins, Sub Queries, CTE, Coalesce, Ranking and Aggregate Functions.
Proficient in creating SSIS packages (ETL process) using various Transformations, Configuring packages for dynamic execution and optimization using features like Auditing, Checkpoints, Transactions, Loggings and Event- Handlers.
Good Understanding of Cube Creation and Optimization Techniques such as Cube Partitioning, Aggregation Wizard and defining Hierarchies with the MOLAP, HOLAP and ROLAP storage structures.
Strong knowledge in reporting Services life cycle (SSRS) right from Authoring, Management to the Delivery phase.
Strong knowledge in designing and developing reports and dashboards by extracting data from different sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files using Power BI and QlikView.
MS Visual Studio, SQL Server Management Studio
•Windows (2000, XP, Vista, 7, 8), MAC
DBMS and BI
•SQL Server 2000, 2008 R2, 2012, 2016, Oracle 11g
•SSRS, SSIS, SSAS, Power BI, QlikView, Tableau
•ER Win 7.0, MS Visio 2003/2007
Option Care Health, OH Sep 2019 - Till Date
Sr. BI Developer
Captured business information needs from stake holders and translated into requirements and functional specifications.
Implemented automated solutions to provide data to third party vendors utilizing SSIS.
Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
Integrate multiple datasets together to build real-time reports using Power BI Desktop.
Supporting the Database Architect in all aspects of database design, in-particular focusing on integrations with legacy systems and appropriate designs and solutions for future integrations.
Lead initiatives with new solutions, and assists in performance and scalability planning; assists with testing as required.
Actively participating in the Governance process associated with technology and database standards.
Providing insight and guidance on the development, review and adoption of integration and database standards and best practices.
Identify data needs and analyze available data; Check for data quality issues and resolving them.
Progressive Insurance, OH Oct 2018 – Aug 2019
Sr. BI Developer
Worked on SQL Server Integration Services (SSIS) 2016 upgrades, Windows Server and SQL Server scans.
Collaborated with different platform SMEs and PMs for CUSTOMER, CORPORATE and CLAIMS Box Cars to gather list of SSIS packages and SSAS cubes to be remediated, tested, communicate and coordinate the project elevate with the dependent teams.
Modified config tables to accommodate 2016 package configuration changes.
Handled the NAS path access issues and raised PIMS requests to get required access to the ZIDs.
Worked closely with BI support team and the DBAs to troubleshoot the issues raised during remediation and when elevated to higher environments.
Was responsible to work with production control to modify and execute ESP jobs on a regular basis.
Performed Windows server scans for unapproved ciphers and SQL scans for breaking changes; analyze the results, eliminate false positives and report concerning results to the platform.
Worked on Object List project to export data from SharePoint and Remedy, create SSIS packages to transform and load data into SQL database and create SSRS reports to visualize the data based on the business needs.
Tracked all the requirements, changes and bugs in tfsprod and worked in both agile and waterfall environments.
JPMorgan Chase, OH Aug 2015 – Oct 2018
Sr. BI Developer
Gathered business requirements and prepared FSD’s which included the technical changes related to the ETL scripts and backend tables.
Created system’s process flow, Logical and E-R diagrams with the help of MS Visio.
Created T-SQL objects like Table, Stored Procedures, Views and UDF, making frequent use of Sub Query, Joins, Dynamic Query, CTE, Temp Tables etc. in order to build ETL scripts to transform the data according to the company standards.
Created SQL server job, troubleshoot SSIS packages and configured them according to the servers.
Used SSIS Packages and the batch process to extract, transform and load data from multiple input sources like Oracle databases, DB2, flat files and excel sheets into SQL Server Staging Database.
Production Support and Bug fixing on the issues by coordinating with QA team and other development personnel.
Designed, developed, implemented, and supported QlikView dashboards. Integrated data sources and databases with QlikView, and designed and developed data models and backend queries for presenting data.
Analyzed underlying data for potential discrepancies, investigated errors, and performed data cleanup.
Built several Dashboards with current year statistics and trending information with the ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.
Worked with Change Management Team for proper approvals and auditing for Deployment and Production changes.
Apple Vacations, PA Aug 2014 – Aug 2015
Worked with the financial services staff, various application managers and Business analysts for requirements gathering, business analysis, testing and project coordination.
Worked with the huge tables that consisted of around 25 columns and 100 million records per each table.
Created SSIS packages to extract data from various sources, transformed it as per the business requirements with the help of control flow tasks and complex data transformations and loaded the data into data warehouse.
Generated ad-hoc and scheduled SSRS reports with the help of report manager and report subscriptions.
Coordinated with the on-call DBA’s and windows support for Production failures and bug fixes.
Was responsible for creating change requests, emergency problem ticket or work requests and manage them for proper approvals and auditing for deployments and change implementation on Production and BCP servers.
Progressive Insurance, OH Aug 2013 – Jul 2014
Prepared HLD and Process flow which included the design and technical details related to the ETL and the final report generation.
Performed Data profiling on the incoming feed with help of SQL scripts and SSIS Data profiling task and extracted the profiling results.
Documented Source to Target mappings along with the table and field logic to populate data as per the business requirement.
Created Stored-procedures, Views and Temp tables to implement the reports logic and created SSRS reports to point directly to respective tables and views with no additional effort at reporting end.
Used SSIS Packages to transform and populate staging and reporting tables with the help of Data flow task, Execute SQL task, Sequence container and Data flow transformations like conditional split, row count, derived column and aggregate.
Co-ordinated with offshore testing team to perform parallel validations on different cycles of test data and report comparison with the source.
Wal-Mart, AR Aug 2011 - Aug 2013
Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
Developed Database objects such as Stored Procedures, Functions, Tables, Views, Cursors, DDL/DML Triggers and Indexes using T-SQL.
Created views and used them as data sources to minimize network traffic between data sources and staging server.
Designed ETL data flows using SSIS; created mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SSIS.
Implemented cubes and optimized them by partitioning and also designing aggregations using SSAS 2005.
Developed SSRS Reports like drill through, drill down, linked, sub reports and parameterized reports for better business analysis.
Was responsible for Preparing and Deploying the Game plan for Business Continuity Process for various Production and Development Servers, which included Replication of the Databases, Migration of Packages & Scripts.
GSS America, India Feb 2008 - Dec 2008
Documented and analyzed business rules, data analysis and modeling, relational and dimensional database design within data warehouse reporting and transaction processing environments.
Performed consistent data entry into the database by developing stored procedures and triggers.
Created various views and materialized views that will be accessed by both the end users and the database administrators.
Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.
EDUCATION: Bachelors of Engineering (Computer Science) - 2008 Hyderabad, India.
Masters in computer science – 2010 California, USA.