Senior Bi Developer / Analyst Resume
Mountlake Terrace, WA
PROFESSIONAL SUMMARY:
- Over 11+ years of experience in IT industry working as BI Developer, Analyst, Data Minor and Software Development Engineer in Test (SDET) with SQL Server 2005/2008/2012 and SQL Server Data Tools (SSDT), C#, Business Intelligence Tools, Requirement Gathering, Analysis, Software Design, Development and Testing.
- Extensive Experience in the Health Insurance Business Domain as Developer, Analyst, Data miner and Reporting.
- Experience in Statistical algorithms, techniques and models to define data for data integrity and process analytics
- Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing and proficient in ETL (Extract Transform Load) using SQL Server Data Tools (SSDT) and SQL Server Integration Services 2012/2008R2/2008/2005 (SSIS).
- Requirement gathering, assessing business rules; performing source to target data mapping; designing, reviewing, implementing and optimizing ETL processes
- Experience in developing BI Data warehouse using Data Stage, Netezza and ERwin
- Expertise in OLTP/OLAP and developed database schemas like star schema and snowflake schema used in relational and multidimensional modeling.
- Experience in designing and implementing data warehouse and BI solutions with Confidential SQL Server Analysis Services 2005/2008/12, Reporting Services 2005/2008/12, SSIS/DTS package, and SQL Server Database 2000/ 2005/2008/12 development Visual Studio.Net, Data Stage and Netezza.
- Excellent technical and analytical skills with clear understanding of design goals of ER (Entity Relationship) modeling for OLTP and dimension modeling for OLAP.
- Expertise in developing and delivering dynamic reporting solutions using SQL Server Reporting Services (SSRS) and Confidential Excel (Pivot tables, Power pivot).
- Experienced in Performance tuning of Queries, indexing to improve Performance and have the ability to code and implement complex business rules in SQL, Triggers and Stored Procedures.
- Exposure to a variety of project methodologies including SCRUM, Waterfall, and ad - hoc methods.
- Created Test plans and Test cases for different projects.
- Experience in developing multi-dimensional Cubes, KPIs, MDX queries,
- Extensive experience in SQL Server SSIS packages to import and transform data between databases and external data sources
- Worked on SSAS Performance Tuning (Enhancing Query Performance, Enhancing Processing Performance and also on how Analysis services uses memory, CPU, and disk resources)
- Experience in SQL Server SSAS in creating Data sources, Data source views, OLAP Cubes and different dimensions for an SSAS project in a Multidimensional environment.
- Reporting Services Ability to design and develop reporting services reports using Report Designer and Confidential Report Builder.
- Extensive experience on Confidential SharePoint Product and Technologies,
- Strong Relational Database and Multidimensional Cubes capabilities using SQL Server 2005/2008/2012 Business Intelligence Development Studio and SQL Server Management Studio.
- Extensive exposure in creating databases, T-SQL scripts, stored procedures, triggers, views, tables, indexes, and constraints, user defined functions, security using SQL SERVER 2005/2008/2012.
- Excellent analytical, co-ordination, interaction skills and an outstanding team player with an aptitude to learn.
- Excellent experience in coordinating tasks with offshore.
TECHNICAL SKILLS:
Data Warehouse Tools: MS SQL Server 2000/ 2005/2008/2012 Analysis Services, Data Mining Tools, Integration Services, Netezza and Datastage
Business Intelligence Tools: SQL Server 2005/2008 R2 Business Intelligence Development Studio, SQL Server Data Tools for Visual Studio 2013
Data Analysis: SSAS, SPSS
Languages: C#, T-SQL, MDX, ASP.NET, XML, HTML
Reporting Tools: MS-Access Reports, SQL Server 2005/2008/ 2008 R2 / 2012 Reporting Services (Report Designer, Report Builder), MS-Excel 2007/2010/13
Development Environment: Visual Studio.Net 2013/10/08/05, 2003 and Visual Studio 6.0, CRM, Onyx, WTT (Windows Test Technologies), Product Studio, AXP, DTW
Data Modeling Tools: Visio
Operating Systems: Windows8/7, Vista, 2003/XP/2000/Me/NT/ 98/95/3.11/3.1
PROFESSIONAL EXPERIENCE:
Confidential, Mountlake Terrace, WA
Senior BI Developer / Analyst
- Gather business requirements and build design specifications for ETL packages and reports
- Familiar with Health Insurance Business Domain & have Knowledge of Trizetto applications (Facets)
- Working on Confidential Services Platform (PSP) on Confidential Cloud using Confidential Azure technologies.
- Participated in the development of many automated services (Member, Group, Eligibility, Group Mandate Services ...etc.…) using Confidential C#.
- Built ETL Code using Custom Netezza SQL scripts and Data Stage and/or Confidential SSIS to pull data from the source systems (FACETS and other sources …) to a 3NF Integrated Relational Database ( Corporate Data Warehouse)
- Built ETL Code using custom Netezza SQL scripts to pull data from 3NF Integrated Relational Database to a star schema Data Mart
- Analyzing IDS Monthly Claims Validation Summary and working on the remediation if there is some discrepancy.
- Built new and update existing SSIS and Datastage Jobs
- Involved in the creation of different SSRS reports.
- Worked on ICD-10 and HIX (Health Insurance Exchange)
- Create Source to Destination Mapping Documents for staging Database
- Create detail design documentation for SQL scripts and SSIS / Data stage jobs
- Used TFS as source control system to check in code
- Used TFS for PBI (Product Backlog Item) and Release Tracking
- Built Unit Testing SQL Scripts
Environment: Netezza, Datastage (ETL Tool), Erwin Data Modeler, Aginity Workbench for Netezza, WinSQL, Visual Studio 2010 /2013 TFS, MSSQL 2008 R2, Confidential SSIS, SSRS, Confidential Visio, SharePoint 2010, Confidential Office 2010.
Confidential, Redmond, WA
Sr. BI Developer/ Analyst
- Confidential Global Business intelligence Team is dedicated to provide of world class BI solutions which maximizes the value of the organization’s information assets by delivering the right knowledge to empower MSCIS to efficiently and effectively achieve strategic, tactical and operational goals.
- Involved in the development of Data quality tool for Global Business Intelligence team which is used to control data quality by creating rules through the web interface which is one of the main concerns of data warehouse/BI apps.
- Participated in SQL Server Integration Services (SSIS) packages to transform data from Manufacturing OLTP environment to GBIDW (GBI Data warehouse).
- Lead an offshore team (India) and managing different projects (provide time and resource estimates, review projects, leading daily sync up meetings, communication with clients on site)
- Fully managed the development of Materials & Failure Analysis and Reliability Engineering test tools development.
- Create package configurations, deploy Integration Services projects and schedule SSIS packages via jobs.
- Creating different flags based on business rules using SSIS.
- Created different Power View presentations using SQL Server 2012 Reporting Services Add-in for Confidential SharePoint Server 2010.
- Created different parameterized reports
- Populate reports into SharePoint portal site from SSRS 2008 R2.
- Responsible in creating a deployment outline and participating in deployments.
- Involved in the Manufacturing Quality Analytics migration project. It was a SQL migration project.
- Worked on Configuration files for Development, User Acceptance Testing and Production environments.
- Involved in the creation of Technical Implementation guide documents for Data Quality, Failure Analysis lab and Reliability Engineering Test Tools.
Environment: BIDS, SSIS 2008/12, SSAS 2008/12 and SSRS 2008, VSTS 2010/12, PowerPivot, C#, MSSQL 2008/2012. TFS.
Confidential, Everett, WA
BI Developer/ Analyst
- Requirement gathering, assessing business rules; performing source to target data mapping; designing, reviewing, implementing and optimizing ETL processes
- Involved in the development of Supply Management Program BI Application for Confidential supply management team using SQL Server, SSAS and the Business Intelligence (BI) tools
- Worked on designing different Star and Snowflake schema designs, dimensional attributes, hierarchies, measures, measure groups, and cube administration.
- Designed and build a Data Mart using dimension and fact tables.
- Worked on SQL Server SSAS in creating Data sources, Data source views, OLAP Cubes and different dimensions for an SSAS project in a Multidimensional environment.
- Developed multi-dimensional Cubes, KPIs, MDX queries, and data mining models.
- Worked on SSAS 2008 Performance Tuning (Enhancing Query Performance, Enhancing Processing Performance and also on how Analysis services uses memory, CPU, and disk resources)
- Created cube driven Report models & also reports with Excel and Reporting Services.
- Create package configurations, deploy Integration Services projects and schedule SSIS packages via jobs.
- Created different Dashboard and Scorecard reports
- Participated in SQL Server Integration Services (SSIS) packages to transform data from Manufacturing OLTP environment to SQL Server Data marts.
- Created different jobs using SQL server agent.
- Research and resolved production issues
- Created System appreciation document for knowledge sharing purpose inside the team.
Environment: C#. NET, Visual Studio 2008/2005, SQL Server 2008/2005, SSAS, SSIS, SSRS, MSOffice 2010, Different Confidential Internal tools.
Confidential
BI and SQL Developer/ Analyst
- Analysis, Coding, Testing, Stored Procedures, documentation, Coordinating tasks with Offshore, DB Redundancy, Creating & Managing Web Jobs, etc.
- Experience in different projects like Web Experience, DB-Redundancy, Gift Card Platform and others for the Nordstrom.com website…
- Experience in designing and implementing DB Redundancy project for the Nordstrom website servers. To avoid fail over for a highly visited website a high degree of Database Redundancy is required.
- Developed different SQL Query script to prepare the data and stored Procedures for the Nordstrom Database Annual and Holiday promotions.
- Creating and manipulating ETL calls through SSIS for the Gift Card Platform (GCP) at Nordstrom
- Developed SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 to migrate data for the Gift Card Platform (GCP)
- Created and documented different logical and physical databases in SQL Server for the Nordstrom database.
- Research and resolved production issues
- Created different jobs using SQL server agent.
- Coordinate and work together with offshore team in INDIA.
Environment: C#. NET, Visual Studio 2008/2005,TFS, Gift Card Platform, SQL Server 2008/2005, SSAS, SSIS, SSRS, Value Center Administrator (A tool for monitoring Gift Card Platform Reports)
Confidential Corporation, Redmond, Washington
Software Development Engineer In Test
- Developed a C# automation for uninstalling and installing different programs for a test run for these teams(Remote tools, Test kits, Setup, Image update and Performance teams)
- Developed SQL Query script to prepare test data and stored Procedures
- Developed C# automation for features of Remote File Viewer and Remote registry editor for remote tools team and working also on Packaging and Versioning features for Image Update Team
- Created Test plans and Test cases for features of Remote File Viewer and Remote registry editor for remote tools team.
- Created Test plans and Test cases for features of Packaging and Versioning for Image Update Team and measuring Performance using Performance Monitor and SQL Server Profiler.
- Developed SQL Query script to prepare test data and stored Procedures for the performance team and measuring performance using Performance monitoring and SQL Profiler
- Developed Code to test stored procedures
- Automating the WTT launch for test pass areas using script files.
- Writing and running automated test cases using VSTS.
- Addressed performance issues associated with stored procedures and fix them.
- Launching Test passes for five teams (Remote tools, Test kits, Setup, Image update and Performance teams) every week based on the latest build.
- Managing so many Servers which contains tools that allows us to launch test passes
- Running performance test and validating data, working on various data using SQL Server 2005/2008
- Doing first hand investigation report on the launch for each team and preparing weekly reports.
- Doing code fixes and reviews in all test pass areas (Remote tools, Test kits, Setup, Image update and Performance teams)
- Creating work flows for each test pass area, and doing maintenance every time if there is any change.
- Creating jobs in WTT.
- Updating team wiki’s with recent reports and documents.
- Preparing Templates for Workflows and Specification documents for each test area
- Filing bugs in product studio for each test pass area
- Automating the WTT launch for test pass areas using script files. Writing and running automated test cases using VSTS.
Environment: C#. NET, Visual Studio 2008/2005, Platform Builder, SQL Server 2008/2005, Windows 7, Windows Vista, Windows XP, Confidential Source Depot, Gate Keeper, Performance testing tools (AXP, Clark Kent) WTT(Windows Test Technologies ); DTW(Distributed Test Workflows), Bug reporting using Product Studio, Cheetah (A tool for running tests and viewing results)
Confidential, Kirkland, Washington
Business Intelligence (BI) Consultant
- Experience in the Design, Implementation and Maintenance of the Glenmede Insurance company data warehouse and BI solutions with Confidential SQL Server.
- Working with business/functional analysts to determine ETL, report and analytical requirements
- Created Data sources, Data source views, Cubes and dimensions for an SSAS project.
- Involved in the complete ETL life cycle and solely responsible for the design, development and maintenance of SSIS packages.
- Participated fully on the Glenmede-Philadelphia SQL Server 2000 to 2005 Migration project starting from the Requirement analysis to the Testing phase.
- Creating and manipulating ETL calls through SSIS
- Developed SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005
- Designed and implemented different kinds of query based interactive reports using Report Designer and Report Builder.
- Extract data from the relational database and prepare reports using SQL Server 2005/2008 Reporting Services.
- Create package configurations, deploy Integration Services projects and schedule SSIS packages via jobs.
- Create Report Services Configuration.
- Participate in full life cycle of SSRS (Authoring, Managing and Delivery reports)
- Used MS Source safe tool for software version control
Environment: Server 2000/2005, SSIS 2005, SSAS 2005, SSRS 2005, C#, ASP.NET, Visual Studio .NET, VSS
Confidential, Silver Spring, Maryland
Software Developer
- Prepared various artifacts including inception report, business process modeling document, requirement analysis document, design document, software architecture document.
- Prepared test plans and Test Analysis document.
- Designed and developing the logical and physical database model.
- Developed the three subsystem modules: Members Registration subsystem, Document management subsystem and Payroll subsystem.
- Customized and used the Confidential data access application block.
- Developed state of the art User interface.
- Designed and implementing different kinds of query based interactive reports.
- Developed a security system for the application.
- Run test cases based on the test specification for the above subsystems
- Fix bugs based on the test result.
- Deployed the application, preparing technical and user manual
- Provided user and system administration trainings.
Environment: C#, ASP.NET, Visual Studio .NET, Rational Rose, SQL Server 2000/2005.
Confidential
Software Developer
- Met with end users of the system to illicit requirements and specified the functional and non-functional requirements for the system in the Software Requirements Specification (SRS).
- Worked on the full-life cycle of the project starting from the initial creation of the Analysis and Design Document up to the deployment.
- Member of the team that designed and developed components and ASP.NET web forms for the system.
- Enhanced productivity in the data access and user interface components by utilizing the Confidential Application blocks.
- Executed Manual and Automated Test cases.
- Responsible for Reporting, Resolving/Fixing and Closing Bugs in the subsystem.
- Created and documented the logical and physical database in SQL Server.
- Wrote Test Plans, created Test Cases, Reproduced and Debugged bugs, and maintained existing tests, worked with Exception handling methods.
Environment: Visual Basic, Visual Studio .NET, Rational Rose, SQL Server 2000, CVS.