Skills

Please use this table to list the skills noted in the Required/Desired section of the Peoplefluent requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

• Skill experience Last date
• Supporting ETL in a production environment, understands and can independently setup/configure SISS packages to run in production
• Senior level SSIS experience, knows control flow and data flow items and can demonstrate usage of each
• Senior level SQL skills that include database development activities
• Data modeling experience hub and spoke, dimensional, data vault
• Has a complete understanding of database normalization and can fluently speak about the various normal forms 1st 6th
• Experience developing/supporting a hub and spoke database architecture, person must have a complete and demonstrable understanding of DW concepts.

Confidential

MS SQL BI Developer

Responsibilities:

• Participated with business analysts in order to gather requirements for design and implementation of database. Performed basic DBA activities like Backup and Restore.
• During the first phase, I have created various SSIS packages, SSAS cubes and various reports in performance point server for Operational matrix like Service level, days on hand for the end users requirements.
• Implemented and supported OLAP reporting user interface enabling ad-hoc queries and multidimensional views for data analysis.
• During the second phase which was for the Finance team, I worked on various data sources which were highly confidential data, to create SSIS packages, SSAS cubes and reports in performance point server where I had to calculate Balance sheets and Gross margin data.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with SSIS and also prepared ETL mapping processes and maintained the mapping documents.
• Created various EXCEL reports for some end users who preferred EXCEL, directly from SSAS cubes.
• Created various automated Stored Procedures in which user have options to insert any month's data, remove data with data verification codes.
• Created various SSIS jobs using SQL server agent to execute SSIS packages and cubes. And worked very closely with DBAs to give Production server support.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created local variables and global variables package configurations and error handling.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler. Also Wrote MDX queries to access data from OLAP cubes.
• Responsible for creating SQL Scripts, Complex stored procedures, Triggers, Indexes, Cursors, various constraints, views, function and variables.
• Responsible for creating and implementation of data access stored procedures and triggers for automating tasks.

Environment: MS SQL Server 2008, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Visual Studio 2008, SQL Server Management Studio , Performance Point server.

Confidential

MS SQL Server /BI Developer

Responsibilities:

• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly budgets reports including current status using global variables, expressions and functions using SSRS.
• Designed and deployed reports with Drill Down, Drill Through, Parameterized, Sub-reports and Linked reports using SSRS.
• White paper on Integrating hub and spoke with point-to-point architecture.
• Created report parameter properties to determine whether parameters are single or multi valued, visible at runtime and set the default values in the run time.
• Designed ETL Extract, Transform, Load strategy to transfer data from source to stage and stage to target tables into the data warehouse tables and OLAP database from heterogeneous databases using SSIS and DTS Data Transformation Service .
• Developed SSIS packages to export data from Excel Spreadsheets to SQL Server, automated all the SSIS packages and monitored on daily basis to resolve the error using SQL Job.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Involved in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Involved in designing and managing scheme objects such as tables, views, clusters, indexes, procedures, triggers and maintained referential integrity using SQL server
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Closely interacted with subject matter experts in understanding the business process methodology.

Environment: MS SQL Server 2008/2005, SSRS 2008/2005, SSIS 2008/2005, SSAS 2008/2005, Windows Server 2003, SQL Profiler, MS Project Server, MS SharePoint, Crystal Reports 10.

Confidential

MS SQL Server / BI Developer

Responsibilities:

• Designed and developed ETL Extract, Transform, and Load strategy to transfer cases data from Informix database to SQL staging area and from SQL staging area to target tables into the data warehouse tables using SSIS.
• Designed and developed SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Generated and deployed various reports using global variables, expressions and functions using SSRS. Performed source data analysis to discover and document data quality issues in the Metadata Repository.
• Participated in development team planning sessions in order to keep abreast of source system architecture changes and develop action plans to handle changes in the data warehouse.
• Implemented and supported OLAP reporting user interface enabling ad-hoc queries and multidimensional views for data analysis.
• Created complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Involved in designing and managing scheme objects such as tables, views, clusters, indexes, procedures, triggers and maintained referential integrity using SQL server
• Managed index, statistics and optimizing queries by using execution plan for tuning the database. Monitored scheduled jobs and alerts created for SSIS packages and SSRS reports in SQL Server
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Enterprise Application Integration using Hub Spoke architecture and Integration Bus architecture.
• Closely interacted with subject matter experts in understanding the business process methodology.

Environment: MS SQL Server 2008 R2/2008/2005, SSIS 2008 R2/2008/2005, SSRS 2008 R2/2008/2005, SSAS 2008 R2/2008/2005, DTS Designer, Data Stage 7.5, IBM Server Studio R7.2,DataStage 7.5/8, WinSQL, SQuirreL SQL, Windows Server 2008, Subversion.

Confidential

MS SQL Server Developer/ SSIS/ SSAS Developer

Responsibilities:

• White paper on Integrating hub and spoke with point-to-point architecture.

• Involved in migrating data from various sources into the SQL Server 2005 using ETL Extract, Transform, Load tool SQL Server Integration Services SSIS .
• All data were migrated to the staging server and then those data were later populated to the OLAP Online Analytical Processing Server to use with SSAS for analysis purpose.
• Involved in designing, implementing and managing data warehouses OLAP cubes to use with SSAS 2005.
• Successfully migrated data between heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP Bulk Copy Program and Bulk Insert.
• Migrated all DTS Data Transformation Service packages to SQL Server Integration Services SSIS and modified the packages according to the advanced feature of SQL Server Integration Services SSIS .
• Implemented and supported OLAP reporting user interface enabling ad-hoc queries and multidimensional views for data analysis.
• Monitored performance and optimized SQL queries for maximum efficiency and implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Implemented calculations to aggregate physical measures and involved in identifying KPIs Key Performance Indicators in SSAS 2005.
• Involved in creating SSIS process design architecting the flow of data from heterogeneous sources flat file, excel, access into target.
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard and improved data load performance by analyzing database design and query plans.
• Involved in designing database objects like indexes, views, user defined functions, triggers, stored procedure, constraints, and roles and documented all the procedures involved in the database for future reference.

Environment: MS SQL Server 2000 Enterprise Edition, MS SQL Server 2005, SSRS, SSIS, SSAS, MS Access 2003, Import and Export Data, MS Project Server, ASP .NET, ADO .NET, HTML

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in logical and physical development of the database using Erwin 3.5
• Built table relationships and wrote T-SQL stored procedures using Query Analyzer in SQL Server 2000.
• Involved in creating complex stored procedures, functions, triggers, cursors, tables, views, and other SQL joins and statements for applications.
• Modified database structures as well as configuration and storage allocation to support application enhancement and automated tasks by creating SQL Jobs in SQL Enterprise Manager 2000.
• Enterprise Application Integration using Hub Spoke architecture and Integration Bus architecture.
• Involved in transferring the data from heterogeneous sources into target source using DTS Data Transformation Service packages.
• Implemented constraints, rules, defaults, user defined data types and Indexes on tables and Monitored and tuned the processing by using SQL Profiler, and Indexes, and efficient queries.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Involved in creating database maintenance plans for backing up the database and transaction log files.
• Resolved deadlocks issues with the Databases/Servers on a real-time basis.

Environment: MS SQL Server 2000 Enterprise Edition, MS Access, DTS Data Transformation Service , Query Analyzer, MS reporting Services, SQL Profiler, Erwin, Windows 2000 Server.