SUMMARY

• Profession of 5 years of IT Experience as a Microsoft SQL Server BI/SSIS/SSRS/ETL Developer implementing database, data warehousing and business intelligence projects using Microsoft SQL Server 2014/ 2012/2008 R2/2008 across various SDLC environments.
• Involved in Database Design, Data Modeling, Development, Programming, Implementation, ETL and Reporting in SQL Server 2012/2008 R2/2008.
• Knowledge developing OLAP Systems (SSRS, SSIS, and SSAS).
• Experience in Data Modeling: Conceptual Data Models, Logical Data Models and Physical Data Models.
• Ability to work with various types and stages of Software Development Life Cycle (SDLC ) processes including Analysis, Design, Development, Testing and Implementation.
• Proven experience in building SSIS projects with multiple packages (and multiple ETLs) from scratch.
• Worked on logical & physical Data modeling, database design, Normalization and De - Normalization techniques for both OLTP and OLAP (Star Schema / Snow flake).
• Involved in designing numerous DB Objects like Tables, Constraints (Primary, Foreign Key, Unique key), indexes, defaults, rules and writing T-SQL Queries and complex joins.
• Involved in writing Complex Queries, heavy stored procedures, Triggers, Functions, Views Using SQL.
• Worked on tuning the performance of Stored Procedures and large T-SQL Queries using Clustered Indexes, efficient Coding standards.
• Ability in designing Enterprise reports, interactive drill down reports, report models and dashboards using SQL Server Reporting Services (SSRS 2012/2008 R2/2008).
• Experience with Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using SQL Server Analysis Services (SSAS).
• Developed cubes using Partitions, KPI’s, Perspectives and Slowly Changing Dimensions.
• Proactive team player with excellent communication, ability to multi-task and take initiative to handle responsibilities independently as well as a team member.

TECHNICAL SKILLS

DBMS / RDMBS: MS Sql Server 2012 / 2008 R2/ 2008, T SQL, Access, TFS

ETL Tools: SQL Server Integration Services (SSIS)

Report Tools: SQL Server Reporting Services (SSRS), Tableau

Data Modeling: SQL Server Analysis Services (SSAS), Tableau

Languages: T-Sql

Operating Systems: Windows Server 2008, 2003, XP

Query Tools: SQL Server Management Studio

Domain Expertise: Mortgage, Trade, Retail

PROFESSIONAL EXPERIENCE

Confidential, Dallas

ETL Engineer

Responsibilities:

• Cleaning client data to either company standards or clients’ standards.
• Write T-Sql scripts to extract data from Source Systems, perform Transformations and load into destinations.
• Analyze the Data in the source to look for Data quality problems and write code to fix Data quality issues or create code to log those errors for reporting needs.
• Write codes to perform business logic on the source data to create output as per expected business needs.
• Perform data analysis as per the project requirements.
• Use SSIS packages as to gather data, perform multiple Control Flow tasks and Data Flow transformations.
• Transformations of Data includes: Applying business rules, Mapping, Cleaning, Filtering, Splitting, Joining, Transposing and Validation.

Confidential

Business Intelligence/SQL Developer/SSIS/SSRS Report Developer

Responsibilities:

• Collected business requirements from users and translated them into technical specifications and design documents for development.
• Build Development and Production Environment on SQL Server 2008 R2 / 2012.
• Designed packages using Lookup Transformations, Merge Joins, and Derived Columns with Multiple Data Flow Tasks.
• Used different type of Transformations for Data Conversion, Sorting and cleaning the data from different sources into company format.
• Created Package Configurations, Event Handlers for On Error/Warning/Task Events.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Automated SSIS Packages using SQL Server Agent Jobs and Windows Scheduler.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-Sql code and Sql joins for applications following SQL code standards.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Developed logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created Parameterized, Cascaded, Drill-down, and Drill-through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for reports.
• Create Report parameters that consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize the execution time and number of records.
• Developed reports using complex T-Sql queries, User Defined Functions’, Stored Procedures and Views.
• Helped in developing Cubes using Sql Analysis Services (SSAS) and extending OLAP Cubes, Dimensions and data source views.
• Created Report Email Subscription using Data and Time Driven Report Subscriptions.

Environment: MS SQL Server 2012/2008 R2/2008, SQL Server Data Tools (SSRS /SSAS/SSIS), T-SQL Enterprise Manager.

Confidential

Business Intelligence/SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs.
• Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of various modules
• Developed Tables, Indexes, Views, complex stored procedures, Triggers, Functions.
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2008) and Excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.
• Built Drill Down, Drill through, linked and sub-reports using SSRS 2008.
• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle and other OLEDB data sources.
• Extracted data from various sources like SQL server 2005/2008, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
• Involved in developing OLAP cubes by identifying tables (fact and dimension), data source and data source views, attributes and dimension members using SQL Server Analysis Services (SSAS)
• Worked on KPIs, design of Star schema and snowflake schema in Analysis Services (SSAS).
• Designed SSIS packages to bring data from OLTP databases to the new data warehouse by performing different transformations like Lookups, Merge Joins,Derived Columns, Conditional Splits, and Data Conversions with Multiple Data Flow tasks.
• Analyzed Performance tuning queries by looking at the Indexes, appropriate joins and Queries.
• Configured Event Handlers for On Error, On Warning, On Task Failedevent types.
• Created Report Email Subscription using Data Driven and Time Driven ReportSubscriptions.
• Dimensional Data Modeling using Star and Snowflake Schemas for Fact and Dimension tables.
• Involved in optimization of Data Models using Kimball Methodology.
• Knowledge using Access Database: Creating/ Updating Queries using T-SQL.
• Involved in DevelopingOLAP Cubes by using SSAS and defined Data Sources, Data Source Views, Dimensions, Measures, Hierarchies, Attributes, Calculations, KPI’s, Perspectives and Roles.
• Wrote T-Sql Scripts to create datasets to perform reporting and included interactive drilldown reports, report models, KPI’s and Dashboard/Scorecard reports.

Environment: Microsoft SQL Server 2008 R2/2008, SSMS, SSIS, SSRS, BIDS, Microsoft Visual studio 2005, Windows server 2003.

Confidential

HR Sr. Manager

Responsibilities:

• Developed and enforced company policy and procedures relating to all phases of human resources activity.
• Offered fair and equitable compensation by comparing current salaries with market pay.
• Managed the employee rewards programs.
• Conducted job analysis and job evaluations, resulting in quality job specifications.
• Audited workplace, employees, management policies and procedures.
• Shadowed employees to determine an accurate description of the duties and skills required for each position.
• Processed unemployment claims and acted as the company representative at unemployment hearings.
• Built a comprehensive employee recruiting strategy.
• Developed and enforced company policy and procedures relating to all phases of human resources activity.
• Team up with other departments’ managers to align strategies.
• Ensured that the Human resources business level strategy is always aligned with the corporate strategy.