We provide IT Staff Augmentation Services!

Lead Msbi (ssis/ssrs) & Sql Server Developer Resume

Orlando, FL

SUMMARY

  • 11 years of experience in Database Design, Development, Testing and Production Environments as a Lead MSBI Developer and Data Analyst.
  • Good experience in development of SSIS, SSRS, Business Objects, Stored Procedures, Triggers, Functions, Views, Index, T - SQL scripts, SQL, PL/SQL, SQL Server for business logic implementation.
  • Good experience with data warehouse modelling of ER, 3NF, and Dimensional Star & Snow Flake Schema models for BI reporting and created Fact and Dimension tables for the Data Warehouse using Erwin.
  • Developing C#.Net, VB.Net scripts as part of ETL (SSIS) Coding.
  • Good experience in creation of SSRS Reports like Tabular, Matrix, Parameterized, Linked, Snapshot, adhoc, Drilldown, Drill through, Sub reports and KPI Dash boards
  • Highly experienced in complete cycle of SQL Server Integration Services ( 2008/2012/2014 ), Packages (Designing, Developing, Deploying, Scheduling, Troubleshooting and Monitoring) for performing data transfers and ETL purposes across different servers.
  • Strong knowledge in Design and development of SSAS in creating cubes, data source views, named queries, dimensions and deployment of analysis services projects.
  • Excellent Knowledge in defining relationships between Dimensions and Measure groups.
  • Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Requirement Gathering, Development, Testing, Migration, Security management, Training and Support.
  • Experienced in migration projects like SSIS packages from 2008 to 2012
  • Good Logical, analytical, interpersonal skills and commitment to perform quality work as well as excellent team member.
  • Development in MSBI (SSIS and SSRS), SAP Business Objects and Data Warehousing applications for Sales, Retail, Recycling, Insurance and Health Care industries.
  • Excellent knowledge in creating Databases, Tables, Stored Procedure, SQL Joins, Sub Queries, DDL/DML Operations, Views, Functions, Cursors and Indexes using T-SQL.
  • Good experience in Performance Tuning, Logging, Error Handling by using event handlers and custom logging, Check Points, Jobs creation, scheduling and monitoring in SSIS packages
  • Scheduled and managed daily/weekly/monthly Patient Status, Dispense, Demographic and Inventory reports in SSRS based on the business requirements.
  • Good experience in creating complex drill, Sub reports and parameterized reports using SSRS 2008/2012/2014 and SAP Business Objects XI 3.1, XIR 2/6.5/6.1/5.1 , BO 4.1/4.2.
  • Proficient in design, development, deployment of SAP Business Objects Universes using Designer (UDT & IDT) and Code migration using PMT in BO 4.1/4.2.
  • Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into designing database, documenting and rolling out the deliverables.
  • Participate in the business team meetings to represent the offshore development team to help the business team with technical feasibility.
  • Responsible for Production, customer issues resolution.

TECHNICAL SKILLS

Primary Skills: MSBI 2008/2012/2014 (SSIS/SSRS), SAP Business Objects XI 4.1/ 4.2/ R 3.1//R 2/6.5/6.1/5.1 and SQL Server 2008/2012/2014 /2016, Oracle 9i/8.x/10g.

Operating Systems: Windows / 98/2000/2003/ XP.

Languages: SQL, T-SQL, PL/SQL, VB .Net, C#.Net.

Development Tools: MSBI SSIS/SSRS Suite, Business Objects (Web Intelligence, Desktop Intelligence, BOMM, QAWAAS, Web I Rich Client, Widgets, Designer, IDT, UDT and Xcelsius Dashboards)

Databases: SQL Server 2005/ 2008/2012/2014 /2016 and Oracle 8i/9i/10g.

Domain Knowledge: Health Care, Insurance, Sales, Banking and Recycling.

Testing Tools: Mantis Testing Tool, PVCS and TFS.

PROFESSIONAL EXPERIENCE

Confidential - Orlando, FL

Lead MSBI (SSIS/SSRS) & SQL Server Developer

Responsibilities:

  • Collaborating with business analysts and process owners to identify opportunities, define business requirements, and assist in designing and implementing solutions to maximize efficiency and productivity
  • Taking responsibility for full life-cycle of project from analysis to design to development to delivery of solutions and performance Tuning
  • Performing data validation and analysis to ensure accuracy and quality of data
  • Developing technical design document for SSIS/SSRS and SQL Server code
  • Working on complete Data Base including ETL & Reporting operations, SQL server operations
  • Creating SSIS packages using various Data transformations like Lookup, Script Task, Send mail Task, Conditional Split, Derived Column, Fuzzy Lookup, Merger, Merge join, Union all, Multicast, Sort, Row Count, File System task, For Loop, For-Each loop containers, execute SQL Task etc..., Deployment and scheduling the SSIS packages by creating the SQL server Agent Jobs, windows task Scheduler
  • Developing C#, VB.Net scripts as part of ETL coding
  • Developing Stored procedures, user defined functions and views for generating different drugs related Patient Status, Dispense, Demographic, Triage and Inventory files and send them through SFTP to corresponding clients
  • Creating and Scheduling SSRS Reports like Tabular, Matrix, Parameterized, Linked, Snapshot, adhoc, Drilldown, Drill through, Sub reports based on user requirement

Environment: SSIS/SSRS 2014, SQL Server 2014, C#.Net, TFS, HTML, XML

Confidential - Los Angeles, CA

Lead MSBI (SSIS/SSRS) with SQL Server Developer

Responsibilities:

  • Worked on complete Data Base including ETL & Reporting operations, SQL server operations
  • Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, Send mail Task, Conditional Split, Derived Column, Fuzzy Lookup, Merger, Merge join, Union all, Multicast, Sort, Row Count, Partition task, For Loop, For-Each loop containers etc...and scheduled the SSIS packages by creating the SQL server Agent Jobs, windows task
  • Developed functional, technical design documents, Run Book and test cases for SSIS/SSRS code
  • Implemented CDC Techniques and applyed standards like logging, check points, and package configurations
  • Developed C#, VB.Net scripts as part of ETL coding
  • Worked SSIS Packages and SSRS Reports development, testing, deployment and performance tuning
  • Developed Stored procedures, Functions, Views, Sub queries, Indexes on tables, tracing and performance tuning
  • Created SSRS Reports like Tabular, Matrix, Parameterized, Linked, Snapshot, adhoc, Drilldown, Drill through, Sub reports

Environment: SSIS/SSRS 2012, SQL Server 2012, C#.Net, Track-IT, TFS, Jira

Confidential - Mayfield heights, OH

MSBI (SSIS) with SQL Server & Business Objects

Responsibilities:

  • Single point of contact for complete Data Base including ETL & BO operations, SQL server operations
  • Developed software solutions by studying requirements analysis and information needs
  • Designed, developed, deployed and maintained key components of the software suite using Business Objects reporting and SSIS
  • Design and development of SSIS packages to fetch data from different data sources
  • Involved in SQL server upgrade from SQL 2008 to SQL Server 2012
  • Worked on development and training environments setup
  • Wrote MS Access Queries based on user’s request
  • Wrote Stored procedures, Views, SQL joins, sub queries, Indexes on tables, tracing and performance tuning for better performance of SSIS packages
  • Participated in discussions with Top Management pertaining to technical design, development and implementation of application systems
  • Actively participated in post-implementation reviews of both application development content and process to maximize and share learnings
  • Worked on multiple projects with different deadlines
  • Developed C#, VB.Net scripts as part of ETL coding
  • Prepared mapping documents and technical design documents based on client requirements
  • Expert in SQL joins, sub queries, tracing and performance tuning for better running of SSIS packages
  • Creation and maintenance of Business Objects Reports and Universes
  • Responsible for Production, customer issues resolution
  • Worked on Business Objects XIR3 including Designer, Desktop Intelligence, Web Intelligence, Info View, Web intelligence rich client and crystal reports
  • Created reports using prompts/ combined queries, report level filters, alerters
  • Created drill and master/detail and linked reports
  • Worked on code migration from BO XIR3.1 to BO 4.1 and SSIS 2008 R2 to SSIS 2012
  • Worked on Business Objects 4.1 including Designer(IDT&UDT), Web Intelligence, Info View, Web intelligence rich client, Promotion Management Tool(PMT), Instance Manager
  • Worked on BO reports and SSIS Packages Deployment, Schedule and monitoring

Environment: BO XI R3/4.1, SSIS 2008 R2, SSIS 2012, SQL Server 2008/2012/2014 , Share point, BO-SDK, Track-IT, C#.net, TFS

Confidential - Montpelier, VT

MSBI (SSIS, SSRS) & BO Lead Consultant

Responsibilities:

  • Preparation of mapping and technical design documents based on client requirement specifications.
  • Represented offshore development team in Business meetings with the client.
  • Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, Send mail Task, Conditional Split, Derived Column, Fuzzy Lookup, Merger, Merge join, Union all, Multicast, Sort, Row Count, Partition task, For Loop, For-Each loop containers etc... and scheduled the same SSIS packages by creating the SQL server Agent Jobs
  • Implementation of CDC Techniques and applying standards like logging check points, and package configurations, error logging by event handlers
  • Developed C#.Net script as part of Script Task in SSIS
  • Created Jobs for various packages that run at specific schedule every day based on dependencies
  • Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements
  • Developed different type of reports by using SSRS and SQL Server 2008/2012
  • Worked on Business Objects XIR3 including Designer, Desktop Intelligence, Web Intelligence, Info View, Web intelligence rich client and crystal reports
  • Created reports using prompts/ combined queries, report level filters, alerters
  • Created drill and master/detail and linked reports
  • Worked on Business Objects 4.1 including Designer(IDT&UDT), Web Intelligence, Info View, Web intelligence rich client, Promotion Management Tool(PMT), Instance Manager
  • Worked on BO and SSIS Code deployment from Dev to UAT/PROD
  • Expert in Index creation, SQL joins, sub queries, tracing and performance tuning for better running of SSIS packages
  • Created sophisticated SQL Server database to responsively handle complex queries (triggers, stored procedures, views, functions) and .Net data access components
  • Held discussions with the business team to understand the requirements based on certain business functionalities
  • Responsible for Production, customer issues resolution

Environment: BO XI R3, BO BI 4.1, MS BI (SSIS and SSRS), SQL Server 2008/2012, Biz-talk, BO-SDK, Mantis, VB.Net/C# .net, PVCS

Confidential

MSBI (SSIS, SSRS) & BO Team Lead

Responsibilities:

  • Understanding business requirement and documenting the same
  • Extensively used ETL Components to Extract Data from Different Sources
  • Design and development of SSIS packages to fetch data from different data sources
  • Worked on Business Objects XIR3 including Designer, Desktop Intelligence, Web Intelligence, Info View, BOMM crawlers
  • Creation of reports using prompts/ combined queries, report level filters, alerters
  • Working on Test cases of SSIS Packages and Data cleansing
  • Developed C#, VB.Net scripts as part of ETL coding
  • Development of UNIT test cases and prepared technical specifications for SSIS packages
  • Implementation of CDC Techniques and applying standards like logging check points, and package configurations
  • Creation of source Queries at Analysis and Designing phase
  • Preparation of mapping documents and technical design documents based on client requirement specifications
  • Creating merged dimensions at report level by using multiple data providers
  • Checking of PDF and excel views of reports for formatting issues
  • Testing of reports for data validation at different levels and preparation of Test results document
  • Universe and Reports Migration from Dev to UAT to Prod
  • Worked in performance tuning and deployment phase
  • Creation of BOMM crawlers on different databases, packages of SQL Server2008
  • Scheduling of BOMM Crawlers
  • Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements
  • Developed different type of reports by using SSRS and SQL Server 2008/2012

Environment: MSBI (SSIS, SSRS), SQL Server 2008/2012, Biz-talk, BO-SDK, Mantis, VB.net, PVCS

Confidential

Data Initiative (FFWR)

Responsibilities:

  • Existing SAS Reports has been developed in Business objects XI R3 environment and automated the process
  • Took backup for all BO Universe’s and report changes during code migrations
  • Solved Mantis ticket issues and provided status updates
  • Coordinating with the production team to move the reports from developing environment to UAT and Production Environments
  • Developed dtsx (SSIS) packages by using design documents and mapping documents
  • Created UNIT test cases and prepared technical specifications for SSIS packages
  • Implemented CDC Techniques and applied standards like logging check points, and package configurations
  • Involved in performance tuning and deployment phase
  • Discussions and updates on issues in status call
  • Created reports using prompts/ combined queries, report level filters, alerts
  • Created merged dimensions at report level by using multiple data providers

Environment: BO XI R3, MS BI (SSIS), SQL Server 2008, Attunity, Mantis, PVCS

Confidential

MSBI (SSIS) & BO Senior Systems Executive

Responsibilities:

  • Worked on BOXI development and Production support for Confidential Security and Confidential Sensing
  • Worked on Business Objects XIR 2 including Designer, Desktop Intelligence, Web Intelligence, CMC, CMS, Info View, Migration
  • Developed and Maintained Universe as per the requirements
  • Created reports using Universe and Excel as main data providers
  • Created Cross Tab, Master Detail and Chart reports using Business Objects functionality’s like Combined Queries, Slice and Dice, Formulas, Drill-down analysis
  • Migration of BO 5.1.8 Reports to BO XI R2 Reports
  • Worked on Scheduling of Reports and monitoring CMS servers.
  • Worked on Universe and Report Migration from Dev to QA to Prod
  • Worked on Assigning the authorization to user depending on his role

Environment: Business Objects5.1.8, Business Objects XIR2, Toad, BODI and Oracle Apps

Confidential

MSBI (SSIS) & BO Senior Systems Executive

Responsibilities:

  • Gathering and analyzing the user requirements
  • Used data that was extracted from different sources and loaded to final warehousing schema
  • Used Business Objects to pull out data from final Data Warehouse and created various kinds of Reports
  • Created classes, objects, derived tables, and @prompts filter conditions at universe level as per the business requirement.
  • Created Context and Aliases for resolving Loops
  • Detected cardinalities, loops, and checked the Integrity of Universes
  • Created the Multidimensional reports by using desktop intelligence
  • Worked on Linking Data providers, Union Queries
  • Created different types of reports such as master/ detail, cross tab, and chart for trend analysis
  • Used filters, conditions, prompts and calculations
  • Developed and modified the existing Stored Procedure as per the business requirement

Environment: Business Objects 5.1.7, Informatica 7.1.3, Oracle 9i, Windows 2000, SQL, PL/SQL

Hire Now