We provide IT Staff Augmentation Services!

Sr. Sql/bi Developer (ssis/ssas/ssrs) - (data Warehouse Architect)/dba Resume

2.00/5 (Submit Your Rating)

Boston, MA

SUMMARY:

  • Around 7 years of IT Experience in design, development, coding and testing of business/commercial applications in MS SQL Server 2014/2012/2008/2005, MS Access, .NET Script, Crystal Report on Windows XP, Windows 2000/2003.
  • Microsoft Certified Technology Specialist in Business Intelligence and SQL Server 2008/2005.
  • Working knowledge of Software Development Life Cycle (SDLC) and N - tier Application Architecture.
  • Extensively used SSIS, SSAS & SSRS for various BI requirements.
  • Very Good Experience in Data Warehouse Created start schema and snow flake schema data model.
  • Extensively worked on ETL process using SQL Server integration service-SSIS to populate data in DataMart, EDW and ODS system.
  • Created summary and details reports on Enterprise data warehouse data using SQL server reporting service.
  • Created Cube on top of DW tables and to read data from cube used Excel Pivot functionality.
  • Experience in MS SQL Server Migration from SQL Server 2000 to SQL Server 2005 and SQL server 2005 to SQL server 2008.
  • Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
  • Worked with fully software development cycle for Business process.
  • Extensively experience in development of T-SQL scripts, MS Integration Services, Stored Procedures and views for business logic implementation, different kind of join to fetch the data from different table.
  • Excellent knowledge in RDBMS concepts and Data Warehouse Concepts.
  • Extensively worked in Data Modeling using Erwin and Visio.
  • Experience in Feeding Data On OLTP and OLAP system using ETL-SQL server integration services.
  • Expert in creating Data Marts, Data warehousing, Operational Data Store (ODS), Data Modeling like Dimensional Data Modeling, Star Schema Modeling, snowflake schema Modeling and good understanding about Fact and Dimensions.
  • Very good experience in Creating SSAS OLAP CUBES and having partition on cubes on yearly bases for good performance, Pulled over those data in Excel pivot functionality sheet as per client requirement.
  • Experience in query optimization & performance tuning.
  • Created Database and Database Objects like Tables, Stored Procedures, Views, user defined data types, different kind of join to fetch the data from different server table and functions using T-SQL queries.
  • Installed and Configured SQL Server 2008R 2/2008/2005.
  • Created Clustered, Non-Clustered Indexes, table partitions and Indexed Views to improve the query performance.
  • Worked with SQL monitoring tool like Idera and Solarwinds.
  • I have Strong troubleshooting, organizational skill, independent and self-managing.
  • Ability to work in-groups as well as independently with minimal supervision.

TECHNICAL SKILLS:

Databases: MS SQL SERVER 2000/2005/2008/2012/2014/2016, MC Access.

Database Tools: T-SQL, Enterprise manager, Query Analyzer, bcp, SQL Agent, my SQL, Erwin, SQL profiler.

Web Servers: IIS 5 and 6

Languages: MS SQL Server 2016/ 2014/2012/2008/2005 /2000, T-SQL, VB.NET

Tools: MS Office 2003/2000/XP, MS Outlook 97/2000.

Reporting tool: SSRS, crystal reports.

Data Modeling: Microsoft Visio, DB Designer, Erwin.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. SQL/BI developer (SSIS/SSAS/SSRS) - (Data warehouse Architect)/DBA

Responsibilities:

  • Experience in Extracting, Transforming and Loading (ETL) data from Flat file, excel (spread sheet), MS SQL and oracle to MS SQL Server database by using SSIS services, BCP utility.
  • SQL Server 2014/2012/2008/2005 RDBMS database development using T-SQL programming queries, stored procedures, views and ETL.
  • ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server.
  • Experience in creating SSIS packages with Error Handling on control flow task and dataflow task, use logging to log the events and worked on package configuration to run package on different environments.
  • Sound Experience in creating static Dimensions called look up tables and dynamic Dimensions.
  • Experience in load data in dynamic Dimensions by using slowly changing dimension Type | and Type || in SSIS.
  • Experience in Error handling on Control flow task by using Send email task to Users and on data flow task putting default dimensions in measures and have them to load on enterprise data warehouse.
  • Used different transformation controls like Look up, Conditional split, data conversion, unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
  • Experience working with delta load for Data warehouse and full load using ETL process.
  • Worked on Big data Hadoop, Installed pseudo distributed mode and fully distributed mode.
  • Worked on ELT using HiveQL tool from big data Hadoop.
  • Experienced Creating reports and dashboard using Tableau data visualization tool.
  • Worked on OLAP Data warehouse, dimensional Modeling, Design, and Implementation.
  • Created SSAS OLAP CUBES and having partition on cubes on yearly bases for good performance.
  • Worked with Excel pivot functionality sheet to pull data from Cubes-SSAA as per client requirement.
  • Created Cube using start schema and created natural hierarchy for N-user and Client to pull more effective information for analysis.
  • Designed data model for data warehouse (logical and physical model) using star schema and snowflake schema.
  • Worked on tracking all data load by using audit tables within SQL server.
  • Worked on deploying SSIS packages on Dev to QA to UAT to Production by using Manifest file and run using DTExec in SQL Server Agent.
  • Created ODS layer and load daily bases data for future for point in time data and in case of flush and reload we can use ODS layer for further enhancements too.
  • Created error handing for each data flow task to quickly figure out what failed in complex ETL packages.
  • Worked on Discover, Design, Development and Deploy End-to-End process for Data warehouse and Software development life Cycle.
  • Knowledge about MOLAP, ROLAP and HOLAP Proactive casing mode for cubes.
  • Understanding about execution plan and estimated execution plan for poor performance query.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Created multiple temporary physical tables to get faster and efficient way data out of multiple tables.
  • Worked on Microsoft team foundation server to store ETL packages, proc and T-SQL.
  • Created summary and details reports using SSRS, deployed them on report server for Users.
  • Created matrix reports, tabular reports, parameterize reports, drill down and drill thought for various applications.
  • Created date driven subscription and started subscriptions for users to refresh reports or send out email to their inbox.
  • Created statics reports and dynamic reports as per user’s requirements.
  • Worked on after job runs successfully shirk log file for data warehouse database and staging database as well.
  • Installed and Configure SQL monitoring tool from Idera and Solarwinds.

Environment: Windows Server, SQL Server 2016/ 2014/2012/2008/2005, ProClarity/PPS, EDW, ODS, business objects xi releases 2 SP5, Biztalk server, Big data/Hadoop, Visualization tool Tableau, Idera, Solarwinds.

Confidential, NJ

SQL/BI developer (SSIS/SSAS/SSRS) - (Data warehouse Architect)

Responsibilities:

  • Experience in Extracting, Transforming and Loading (ETL) data from Flat file, excel (spread sheet), MS SQL and oracle to MS SQL Server database by using SSIS services.
  • SQL Server 2008/2005 RDBMS database development using T-SQL programming queries, stored procedures, views and ETL.
  • ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
  • Experience in creating SSIS packages using different type of task, with Error Handling on control flow task and dataflow task, use logging to log the events and worked on package configuration to run package on different server.
  • Sound Experience in creating static Dimensions called look up tables and dynamic Dimensions.
  • Experience in load data in dynamic Dimensions by using slowly changing dimension Type | and Type || in SSIS.
  • Experience in Error handling on Control flow task by using Send email task to send particular developer and Users and on data flow task putting default dimensions in measures and have them to load on enterprise data warehouse.
  • Used different transformation controls like Look up, Conditional split, data conversion, unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
  • Experience in Delta load for Data warehouse after finish initially process full load using ETL process.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Created SSAS OLAP CUBES and having partition on cubes on yearly bases for good performance, pulled over those data in Excel pivot functionality sheet as per client requirement.
  • Created Cube using start schema and created natural hierarchy for N-user and Client to pull more effective information for analysis.
  • Designed data model for data warehouse (logical and physical model) using star schema and snowflake schema.
  • Worked on tracking all data load by using truncation audit tables within SQL server.
  • Worked on deploying SSIS packages on Dev to QA to UAT to Production by using Manifest file and run using DTExec.
  • Created EDS layer and load daily bases data for future for point in time data and in case of flush and reload we can use EDS layer for further enhancements too.
  • Worked on Discover, Design, Development and Deploy for Data warehouse cycle.

Environment: Windows Server 2003, SQL Server 2008/2005, ProClarity/PPS, EDW, ODS, EDS, business objects xi releases 2 SP5.

Confidential, CT

SQL/ ETL Developer - SSIS (Data warehouse)/SSAS

Responsibilities:

  • Experience in Extracting, Transforming and Loading (ETL) data from multi CSV files, XML to MS SQL Server database by using SSIS services.
  • Worked on for each loop container and sequence container in SSIS control flow task.
  • SQL Server 2005 RDBMS database development using T-SQL programming queries, stored procedures, views.
  • ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning that way ETL process after staging more clear and efficient.
  • Used CTE to maintain parent and child relationship.
  • Used SSIS functionality and capture error log for each steps of job in transaction audit table and created SP for balancing purpose to make sure counts are correctly loaded.
  • Worked on deploying Cubes in SQL server management studio using deployment wizard and created partition on that for good performance point and having process full and process update for all DIM.
  • Worked on child-master package concepts in ETL using SSIS.
  • Sound Experience and understanding of SSIS, SSAS, OLAP cube, and dimensional modeling on terabytes database.
  • Worked on Data warehouse Design and Implementation.
  • Defined relationship between dimensions and measures groups in DSV (Data source view) and created prospecting cubes in OLAP to avoid complexity of cube and security purpose.
  • Worked on slowly changing dimensions in ETL Process.
  • Good understanding about role play dim, junk dim and degenerated dim for DW design.
  • Created calculated measure and aggregation in cube for user and faster retrieval of data out of cube.

Environment: Windows Server 2003, SQL Server 2008/2005, SSIS, SSAS, SSRS, ProClarity/PPS, EDW, ODS.

Confidential

Jr. SQL/ ETL Developer - SSIS (Data warehouse)

Responsibilities:

  • Worked with different methods of logging in SSIS.
  • Use SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts (OLAP).

Environment: SQL Server 2005, BI studio 2005, SSIS, SSAS, SSRS, Microsoft windows XP, Data modeling tool Erwin 4.1 .

We'd love your feedback!