Sql, SSIS

MOSES

Mail ID: *****.***.****@*****.***

Mobile No: 202-***-****

Professional Summary:

5+ years of industry experience in development and implementation of business requirements with Microsoft .Net technologies, SQL Server 2016/2014/2012/2008/2005/2000, oracle 8 and oracle 9g with front-end tools like VB.NET, C#.NET. ASP. NET, VB Script, HTML

Performed the role of Sr. MSBI Consultant/Sr. SQL developer/Programmer.

Experience in database programming and optimization ETL strategies using SSIS/SSRS/SSAS. Capable to developing/supporting Power BI, Business/Web Application using Visual Basic, Database designing using SQL Server 2000/2005/2008.

Expertise in Requirement analysis, Database design, Data modeling and complete software lifecycle.

Experience in Extraction, Transformation and Loading (ETL) in SQL Server database.

Experience in supporting multiple production database servers

Expert in creating complex stored procedures, and queries for the application team and for the end users based on the business requirements.

Expert in T-SQL PL/ SQL coding, testing functions, ad-hoc SQL queries, views, triggers, cursors, data types, indexes, and system tables.

Worked with lots of data by creating spreadsheets in MS EXCEL

Knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analytics Services (SSAS).

Excellent knowledge & experienced in creating databases, tables, stored procedures, DDL/DML Triggers, Views, User defined datatypes, effective functions, cursors and indexes using T-SQL.

Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.

Developed, monitored and deployed SSIS packages.

Experience in T-SQL, SSIS, SSRS, BI suite, Reporting and Analytics and knowledge in OLAP

Excellent experience in migrating DTS packages from SQL Server 2000 to SQL Server 2005 and SQL Server 2008, 2014, SSIS packages.

Experience in MS SQL Server Installation, Configuration, Performance Tuning, client/server connectivity, building servers, trouble shooting, clustering, query optimization, back-up/recovery, running Database Consistency Checks using DBCC and troubleshooting on large databases and maintaining, supporting, monitoring production and test environments

Excellent experience in AX, MS Dynamics, Micro strategy, Reporting implementation of Crystal Reports/ SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)

Having Good communication and Interpersonal skills, hardworking, dedication at work and result oriented as an individual and in a team.

TECHNICAL SKILLS:

Languages : C#, T-SQL, PL/SQL

Business Intelligence : BIDS, SSIS, SSRS and SSAS.

Operating Systems : Windows Server 2003/2008/2008R2 and Windows

XP/Vista/7.

Framework : Microsoft .NET 3.5 and 4.0.

Databases : SQL SERVER 2005/2008/2014/2016, MS-Access, MS EXCEL

Database Tools : SQL Server Management Studio, ETL Tools, and OLAP.

Applications & IDE : MS Visual Studio 2008/2010, POWER BI Development Studio, Visual Basic, Linux, MAC, Windows.

PROJECT SUMMARY:

Freddie Mac, McLean, Virginia Mar 2017 – Present

SQL/MSBI Developer [SSIS, SSRS & SSAS]

Description: Freddie Mac, is a public government-sponsored enterprise (GSE), headquartered in Fairfax County, Virginia. The FHLMC was created in 1970 to expand the secondary market for mortgages in the US. Along with the Federal National Mortgage Association (Fannie Mae), Freddie Mac buys mortgages on the secondary market, pools them, and sells them as a mortgage-backed security to investors on the open market. This secondary mortgage market increases the supply of money available for mortgage lending and increases the money available for new home purchases. The name, "Freddie Mac", is a variant of the initialism of the company's full name that had been adopted officially for ease of identification.

RESPONSIBILITIES:

Developing ETL packages (SSIS) for Data warehouse.

Involved in queries optimization using tools such as SQL Profiler, Tuning Advisor, Execution Plan and statistics IO.

Involved working in project by creating crystal reports and micro strategy.

Create Tables, Indexes, Views, Sequences, Constraints, Synonyms and Partitions (Range and List partitions).

Worked on SSIS Packages Documentation, source, archive, Stage path mapping.

Develop Exception handling process and audit process for each ETL package.

Developing SQL code such as writing complex queries, stored procedures, user defined function etc.

Monitor and SQL profiler and tuned queries and procedures to boost database performance.

Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Script, Merge Join, Sort and Execute SQL Task, SCD to load data into Database.

Involved in creating proxy accounts and Scheduling Jobs to execute SSIS packages.

Responsible for creating database objects like table, Views, Store Procedure, Functions using T-SQL to provide structure to store data and to maintain database efficiently.

Created and managed Interactivity Financials SSRS reports (Parameterized, Linked, Drilldown, Drill through reports)

Extracting data from source systems and bringing the data into the data warehouse using ETL.

Prepared Mapping documents and design documents for data conversion.

Using Team Foundation Server (TFS) for Configuration Management and Version Tracking.

Environment: AX, Power BI, SQL Server 2016/2014/2012/2008/2005 R2, 2012, SSRS, SSIS, Windows Server 2008 R2, Visual Studio 2010, C#.Net, Oracle 9i, Teradata, TFS, Crystal Reports, Micro strategy, MS Dynamics

CAPITAL ONE, McLean, Virginia Mar 2016 - Feb 2017

SQL DEVELOPER

Description: Capital One bank offers a broad array of financial products and services to consumers, small businesses and commercial clients. I was responsible for implementing policies and procedures for ensuring the security and integrity of the company database.

RESPONSIBILITIES:

Work closely with the Banking projects & Business analysts for requirements gathering, designing the database and creating workflow for report.

Developing SQL code such as writing complex queries, stored procedures etc.

Have worked in projects involving crystal reports, AX and micro strategy.

Responsible for creating database objects like Indexes, Table, Views, Store Procedure using T-SQL to provide structure to store data and to maintain database efficiently.

Being active part of Database designing team, to identify integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.

Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Script, Merge Join, Sort and Execute SQL Task, Script Component Task to load data into Database.

Designed the staging database in order to extract and load the data from various sources optimally.

Develop Exception handling process and audit process for each ETL package.

Created types of SSRS report (Parameterized, Linked, Drilldown, Drill through, Customized, dashboards, graphics) in SharePoint environment.

Analyzing financial reporting data with the existing Data Warehouse system environment. Exporting data load from landing area to Tabular Mode environment in SQL Server 2012

Developed detail and summary Financials reports, line and pie chart, trend analysis reports and sub reports according to business requirement using Power View /Pivot Table, Report builder and SSRS and Tableau.

Developed detail and summary Quality and Test Result reports, line and pie chart and sub reports according to business requirement using Report builder and SSRS

Involved in creating proxy accounts and Scheduling Jobs using SQL Agent to execute SSIS packages.

Extensively worked on Consuming Web Services using SSIS Script Task.

Create Scheduling for Database Backup and SSIS packages.

Environment: AX, Power BI, SQL Server 2014, 2012, SSRS, SSIS, Visual Studio 2010, C#.Net, Windows Server 2008R2, MS Tabular Model, DAX, SSAS, Power Pivot, Tableau, Web Services, Crystal Reports, Micro strategy, MS Dynamics

PWC INC, Florida Sept 2015 – Feb 2016

Business Intelligence Developer

Description: PWC is a multinational professional services network. It is the second largest professional services firm in the world, and is one of the Big Four auditors, along with Deloitte, EY and KPMG Vault Accounting 50 has ranked PwC as the most prestigious accounting firm in the world for seven consecutive years, as well as the top firm to work for in North America for three consecutive years.

RESPONSIBILITIES:

Involved in gathering user requirements and documenting the Technical specification analysis based on functional needs.

Designed and developed Proof of Concepts for various BI software evaluations.

Conducted research and made recommendations on BI products, services and standards in support of procurement and development efforts.

Dealt with the third party vendor (4Sight) for resolving issues, finding software related bugs and gave recommendations to resolve it.

Worked with different business users in setting up data marts based on their Analysis/Reporting needs.

Developed SQL scripts /libraries for various data loads and validation for both OLTP and OLAP systems.

Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end applications.

Created and altered Databases, Tables, Views, Indexes and Constraints with business rules using T-SQL across all SDLC environments.

Used Temporary tables, Table variables and Common Table Expressions (CTE's) depending on the requirements.

Worked on Performance tuning, query optimization and execution plan of queries for better performance.

Performed Code reviews for Production Deployments.

Worked with SSIS for transferring and reviewing data from heterogeneous sources like Flat file, Excel, CSV and DB2.

Used project level parameters for connection strings and other variables in order to map the Environments accordingly for Dev/QA/Prod.

Used Cache Transforms for the Lookups especially while loading the Dimensions.

Implemented SSIS features for Incremental Data Loads, Slowly Changing Dimensions for updating and maintaining the history of the records.

Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.

Extensively used SSIS for Transformations, Aggregations and Lookups.

Followed standards & Naming Conventions while creating Packages and applied the best practices for efficiency and performance of the Packages.

Debugged the SSIS errors by configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fixed the errors.

Created Complex SSIS Packages using various data transformations like Conditional Splits, For Each loop, Multi cast, Fuzzy grouping etc.

Worked on Dimensional Modeling in defining Relationships between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, and Dimension Granularity within a Measure Group.

Designed and developed KPIs, Aggregations and Hierarchies.

Created complex SSAS/Mondrian cubes with multiple fact measure groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Designed & developed Dashboards, Score cards and (150+) reports for different departments.

Designed Tabular reports, Cross Tab Reports, Matrix reports, List reports & parameterized reports and with different techniques like Drill down, Parameterized, Pie charts, Graphs, Linked Reports, Drill Through using Expressions, Global variables and Functions.

Created MTD/QTD/YTD Reports for management.

Designed Ad-Hoc reports as per the client requirements using PowerPivot.

Involved in supporting more than 80+ Users for various Reporting and Analytics requirements across multiple Business Units and departments.

Performed training for new employees about the MSBI tools especially SSRS and helped them to learn the tools.

Environment: MS SQL Server 2012/2008/2005/2000, Visual Studio, SQL Server Reporting Services (SSRS /2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server, Data Tools (Business Intelligence Development Studio (BIDS)), T-SQL, MDX, MS Excel, Team Foundation Server (TFS), Pentaho Integrated Solutions, Pentaho Spoon for ETL, Mondrian Cubes Editor- Schema Work Bench, Pentaho Web Console.

Nielsen Software Solutions, Florida Jan 2015 – Aug 2015

SQL Developer

Description: Nielsen software solutions is a Software publishing, consultancy and supply Software publishing includes production, supply and documentation of ready-made (non-customized) software, operating systems software, business & other applications software, computer games software for all platforms. Consultancy includes providing the best solution in the form of custom software after analyzing the users' needs and problems. Custom software also includes made-to-order software based on orders from specific users. Also, included are writing of software of any kind following directives of the users; software maintenance, web-page design Software publishing. Also, included are writing of software of any kind following directives of the users; software maintenance, web-page design.

Responsibilities:

Study and understand the requirements of the information required by company's Procurement.

Department about the vendors.

Designed T-SQL scripts to identify long running queries and blocking sessions.

Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.

Data migration (import & export - BCP) from Text to SQL Server.

Error handling using Try-Catch Block.

Normalization and De-Normalization of tables.

Developed Backup and Restore scripts for SQL Server 2005.

Installed and Configured SQL Server 2005 with latest service packs.

Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.

Written T-SQL queries for the retrieval of the data.

Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.

Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.

Environment: SQL Server, T-SQL, Enterprise manager, VBS, MS Office & Windows 2K platform.

Synopsys, India Jan 2012 – Dec 2014

SQL Server Developer

Canada Pacific Railways (CPR)

Description: At CPR, Car Management metrics are used across various departments and are published to the Operations Dashboard and 0700 for senior Canadian Pacific management. The BI Initiative will provide a significant upgrade to the current Car Metrics process. Metrics will be centralized into a Car Management Portal in a supported BI environment. Data will have consistent business rules, hierarchies and standardized metrics and calculations.

RESPONSIBILITIES:

Understanding the business requirements and designing applications to meet their needs.

Written complex stored procedures which meet the requirements.

Involved in creating and designing packages using SSIS by using the existing tasks and transformations.

Created and managed the management, marketing and sales reports by using SSRS 2005 and report manager.

Deploying the generated reports on production server.

Also, prepared documentation for the generated reports.

Environment: SQL Server 2005, SSRS, SSIS, Visual Studio 2008, C#.Net

Contact this candidate