We provide IT Staff Augmentation Services!

Lead Sql Server/ssis/ssrs Developer Resume

Chicago, IL

SUMMARY

  • 11+ Years of experience in the Information Technology with specialization in all phases of Software Development Life Cycle (SDLC) and AGILE methodologies of Analysis, Design, Development and Implementation, Integration and Testing, deployment and maintenance
  • Extensively worked and used SSRS, SSIS, Power BI, Tableau 7, 8,9.2, Crystal Reports - Crystal Reports 9, 10, Xi Family, Business Objects Enterprise R2, Informatica 8.6
  • Excellent skills in High Level Design of and implementing ETL packages using SSIS 2008/2012 for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookup and Union all.
  • Good Hands on experience in Data Warehouse Design and analysis of various approaches for maintaining different dimensions and facts in the process of building a data warehouse application.
  • Well versed in Data warehouse concepts normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
  • Strong experience of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for fact and Dimension Tables using Analysis Services.
  • Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Experience in building robust Architecture to organize Data flow from various homogeneous and heterogeneous system using SQL Server Integration Services (SSIS) and Data Transform Services (DTS).
  • Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SSIS.
  • Experience in designing enterprise reports using SQL Server Reporting Services, generated drill down reports, drill through reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.
  • Power BI experience in designing Interactive Reports and Data Visualization using Power BI Desktop.
  • Extensive experience on building dashboards using Tableau
  • Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online
  • Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
  • Experience in Creating, Modifying Measures, Dimensions Attribute relationships and Hierarchies.
  • Extensive experience in software size estimation, cost and resource estimation, RFP - proposal writing, due diligence study and project management skills, technical presentation, client liaison
  • Architected data warehouse from requirements gathering to conceptualization to creation of data marts
  • An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management
  • Experience in Agile methodologies (SCRUM) and traditional methodologies.
  • Experience in a SCRUM-based Agile environment.

TECHNICAL SKILLS

Reports: SQL Server Reporting Services, OBIEE, Crystal Reports v 8.0, 9.0, 10, XIR2, Tableau 8.2,9 Business Objects R2

RDBMS: MS SQL Server v 2005, 2008, Oracle 9i &10g, MS Access 2000.

ETL: SSIS 2008, 2012, Basic knowledge of Informatica power center

Operating System: Window s XP Professional, Windows 7

Version Control Systems: Ebi Experts version Manager, MS Visual Source Safe (VSS)

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Lead SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Develop solution in highly demanding environment and provide hands on guidance to other team members.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Data warehouse database
  • Developed, deployed, and monitored SSIS Packages.
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008/2012.
  • Performed operations like Datareconciliation, validation and error handling after Extracting data into SQL Server.
  • Created SSRS reports using Report Parameters,Drop-DownParameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Conduct impact assessment and determine size of effort based on requirements.
  • Assist and verify design of solution and production of all design phase deliverables.
  • Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.
  • Resolve difficult design and develop issues.
  • Identify bugs when developers are not able to do so.
  • Lead in designing, specifying and selecting information system solutions, considering functionality, data, security, integration, infrastructure and performance
  • Estimate cost, and prepare business cases for IT solutions, considering infrastructure, licenses, development and support
  • Work with the Project Managers and Business Analysts to develop high level project schedule resource plans for implementation projects.

Environment: MSSQLServer2008/2012,SQLReporting Services (SSRS),SQLIntegration Services (SSIS), Power BI, Tableau 9 Office2007, Oracle 10g, Windows Server 2008 R2.

Confidential, Milwaukee, WI

Lead SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Gathered user requirements. Responsible for Analysis and implementation for DB changes requested by users. Developing reports usingefficient data retrieval techniques
  • Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
  • Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
  • CreatedSSISpackages for File Transfer from one location to the other using FTP task.
  • Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. .
  • Wrote queries fordrill down reportsto get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports usingGlobal variablesand expressions. Deployed generated reports onto theReport Serverto access it through browser.
  • Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
  • Involved to convert existing BO reports into tableau dashboards using tableau 8.2
  • Support Activities to document, evolve, and communicate artifacts developed using Tableau
  • Involved in performance tuning of TSQL queries and Stored Procedures.
  • Optimized query performance by creating indexes.
  • Provided the knowledge transfer to the MSBI supporting team
  • This Project has developed using agile methodology and involved in various phase of agile such as daily scrum, Sprint goal, sprint review etc.

Environment: MSSQLServer2008,SQLReporting Services (SSRS),SQLIntegration Services (SSIS), SharePoint, Tableau 8.2

Confidential, Virginia Beach, VA

Sr. SQL Server/SSIS Developer

Responsibilities:

  • Analysis the report requirements given by the business
  • Develop the stored Procedures and SSIS Packages as per the requirement
  • Test the procedures and packages in the local environments.
  • Involved Code review & Unit Test Plan
  • Involved the performance tuning for the developed Stored Procedures
  • This Project has developed using agile methodology and involved in various phase of agile such as daily scrum, Sprint goal, sprint review etc.

Environment: MSSQLServer2008,SQL,SQLIntegration Services (SSIS), Business Objects

Confidential, Virginia Beach, VA

Sr. SQL Server/SSIS Developer

Responsibilities:

  • Develop the stored Procedures based on the specifications given by the business customers
  • Worked on Defect Analysis & Code Fix.
  • Involved various Data extracts using SQL Scripts and sharing to Business.
  • Involved Code review & Unit Test Plan.
  • Involved the performance tuning for the developed Stored Procedures

Environment: MSSQLServer2008,SQL,SQLIntegration Services (SSIS), Business Objects

Confidential, Seattle, WA

Sr. SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Develop the report based on the specifications given by the business customers
  • Create the stored procedures which will be used to develop the SSRS reports
  • Analysis of Report requirements
  • Test the reports in the local environments.
  • Involved the performance for the developed Stored Procedures

Environment: MSSQLServer2008,SQL,SQLIntegration Services (SSIS), SQLReporting Services (SSRS)

Confidential, Scottsdale, AZ

Sr. Informatica Developer

Responsibilities:

  • Responsible for managingthe Development, maintenance and support to achieved the highest level of customer (end user) acceptance and satisfaction within Service Level Agreements (SLA).
  • Managed stakeholdersthrougheffectively communicatingproject plans, progress, expectations, assumptionsanddependenciesin a timely and clear fashion throughout the project.
  • Involved inUATand helped business users to test the solution before implementation.
  • Pear review of the reports and mappings developed and tested by the team to confirm with standards

Environment: Business Objects R2, Informatica 8.6, Oracle 10g, Ebi Experts Version Manager.

Confidential, Hartford, CT

SSIS/SSRS Developer

Responsibilities

  • Develop the SSIS packages for extracting the data from Data warehouse to Provider portal database.
  • Create stored procedures and functions which will be used to load the data into Provider portal for delta load
  • Analysis of Report requirements
  • Involved in Report Development.
  • Test the reports in the local and infoview environments.
  • Involved the performance tuning of the ETL packages and Stored Procedures

Environment: MSSQLServer2005,SQL,SQLIntegration Services (SSIS), SQLReporting Services (SSRS)

Confidential, Hartford, CT

SSIS/SSRS Developer

Responsibilities

  • Develop the SSIS packages for extracting the data from Data warehouse to Online Enrollment database.
  • Create stored procedures and functions which will be used to load the data into Online Enrollment for delta load
  • Analysis of Report requirements
  • Involved in Report Development.
  • Test the reports in the local and infoview environments.
  • Involved the performance tuning of the ETL packages and Stored Procedures

Environment: MSSQLServer2005,SQL,SQLIntegration Services (SSIS), SQLReporting Services (SSRS)

Confidential, Hartford, CT

SSIS/SSRS Developer

Responsibilities

  • Develop the SSIS packages for extracting the data from Source System to Data warehouse.
  • Create stored procedures and functions which will be used to load the data into dimensions and fact tables
  • Involved the performance tuning of the ETL packages and Stored Procedures
  • Unit Testing
  • Worked as an offshore lead for a team of five and completed the project.

Environment: MSSQLServer2005,SQL,SQLIntegration Services (SSIS), SQLReporting Services (SSRS)

Confidential, Hartford, CT

Crystal Reports Developer

Responsibilities

  • Analysis the business requirements.
  • Create a LOV’s for the Reports.
  • Develop the reports as per the requirement.
  • Develop the stored procedure based on requirements with DB2
  • Test the reports in the local and infoview environments.
  • Co-ordination with the onsite coordinator (Status update calls).
  • Worked as an offshore lead for a team of three and completed the project.

Environment: Crystal Reports XIR2, IBM DB2

Confidential, Hartford, CT

Crystal Reports Developer

Responsibilities

  • Analysis the existing business requirements.
  • Create a LOV’s for the Reports.
  • Develop the stored procedure based on requirements with DB2
  • Develop the reports as per the requirement.
  • Test the reports in the local and infoview environments.
  • Co-ordination with the onsite coordinator (Status update calls).
  • Worked as an offshore lead for a team of three and completed the project.

Environment: Crystal Reports XIR2, IBM DB2

Confidential, Hartford, CT

SSIS/SSRS Developer

Responsibilities

  • Develop the SSIS packages for extracting the data from Source System to Data warehouse.
  • Create stored procedures and functions which will be used to load the data into dimensions and fact tables
  • Analysis of Report requirements
  • Create reports based the business requirements
  • Involved the performance tuning of the ETL packages and Stored Procedures
  • Involved in Report Development.
  • Report field alignment to meet business requirement.
  • Testing the reports at local environment.

Environment: MSSQLServer2005,SQL,SQLIntegration Services (SSIS), SQLReporting Services (SSRS)

Hire Now