SUMMARY:

• Intensive learning on several Business Intelligence technologies and environments. More dedicated, euthanistic hard worker and work for career development
• Over six years’ hand - on experience in building business intelligence infrastructure and solutions.
• Combined the various steps of system development life cycle (SDLC) in all my projects.
• Well experienced in writing complex T-SQL queries: stored procedures, user defined functions, databases, tables, CTEs, views, subqueries, multiple joins etc.
• Proficient in the three main Microsoft Business Intelligence technologies of SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Proficient in MS SQL Server 2008/2008R2/2012 Integration Services (SSIS) for maintaining data extractions, transformations, and loading (ETL).
• Skillful with MS SQL Server 2008/2008R2/2012 Reporting Services (SSRS) in developing reports for summarizing and analyzing key analytics findings.
• Proficient in Ralph Kimball’s data modeling concepts.
• Expertise in performing performance tuning of data warehouse using indexes, indexed views, non-default locking options, aggregations, and partitions.
• Expertise in translating business requirements into system design and implementation.
• Proficient in agile methodology using the SCRUM process framework.
• Fast learner and active to adapt new changing technologies.

TECHNICAL SKILLS:

RDBMS (Database): SQL Server Management Studio 2005/2008/2008 R2/2012

Integration: SQL Server Integration Server 2005/2008/2008 R2/2012

Analysis: SQL Server Analysis Service 2005/2008/2008 R2/2012

Reporting: SQL Server Reporting Service 2005/2008/2008 R2/2012

Languages: T-SQL, MDX, DMX and Visual Basic .Net

OS: Windows XP/Vista/Window 7/Window 8/Window 10

Analysis: SQL Server Analysis Service 2005/2008/2008 R2/2012, MS Excel 2003/2007/2010/2012

ERD Tools: Entity Relationship Diagram (ERD) building with ERD Assistance tool, Microsoft

Other Tools: MS Visio 2003/2005/2010, Team Foundation Server, SharePoint Server 2007/2010, Microsoft Visual Source Safe

Architecture: OLAP, OLTP\

Methodologies: Ralph Kimball’s Data Modeling, Agile, Project Management and Six Sigma.

PROFESSIONAL EXPERIENCE:

Confidential, MD

Senior BI Developer

Responsibilities:

• Coming up with an appropriate database design and application architecture through intensively analyzing the clients' requirements.
• Performed an active role in the entire SDLC (planning, requirements analysis, design, build, test and deployment) activity and applied agile methodology for the development process.
• Developed several ERD Diagrams through logical/conceptual and physical (forward engineering) as per required processes.
• Data normalization using SQL Server Management Studio.
• Using T-SQL; created Tables, Constraints, Store Procedure, User Defined function, Views, and Indexes.
• Tuned SQL statements for efficiency using Indexes and Database Maintenance.
• Extracted data from MS Excel 2003, Oracle 11g, DB2 data sources and load it into the Data Warehouse (SQL Server Management Studio) using SQL Server Integration Service (SSIS) 2012.
• Applied various Control Flow Tasks (CFT) such as Execute SQL, Data Flow Task, Package Execution Task, For Each Loop Containers and For Loop Containers.
• Applied various transformations such as Derived Column, Union All, Merge Join, Data Conversion, Conditional Split, Fuzzy Lookup and Lookup.
• Applied SQL Server based configuration and parameters for all my SSIS projects.
• Wrote various T-SQL's Joins and Stored Procedures that ran against the SQL Server Management Studio for SQL Server Reporting Services (SSRS) 2012.
• Created several types reports: tabular, parameterized, drill down/drill through and sub reports.
• Used SQL Server Analysis Services (SSAS) 2012 to develop Analysis Service Cubes.
• As a senior BI developer, I worked with other BI Team when they have technical issues.
• I participated in different meetings with business user about the teams’ project as well as my project.
• I participate in making decisions on the database model and worked on refining the requirement.
• Prepared and reviewed test plan. Did Unit, Performance, Functional, Volume and System Testing.

Environment: SQL Server 2008/2008R2/2012 (Management Studio, Integration Services, Reporting Services, and Analysis Services), Visio 2007/2010, T-SQL, Subversion, Report Manager, MS Excel 2007/2010 and Windows Server 2008/2008R2/2012.

Confidential, Birmingham, Al

SQL Server ETL Developer

Responsibilities:

• By Interacting with functional teams build an Entity Relationship Diagram (ERD) development to understand the data structure, constraints, and integrity.
• Participated in writing Extract Transform Load (ETL) and Report Specification Documentations.
• Prepared ETL Standards and Naming Conventions
• Participated in designing Dimensional Model and combining information from several business support systems, including the Financial System, HR System, Performance Management System, and Payroll.
• Perform SQL Server 2005/2008 Integration Services (SSIS) process to extract data from XML, Flat File and OLE DB sources.
• Perform various transformations such as Derived Column, Aggregate and Data Conversion.
• Used SSIS’s Slowly Changing Dimension (Type 1 and Type 2) for updating and inserting records into Employee Dimension tables.
• Performed Debugging Control flow by using Transactions, Checkpoints, and Partial Execution (to save debugging time) of packages.
• Used Data Viewers for data count verifications.
• Optimized and Tuned SSIS Packages by Buffer Settings, Parallelism, and Log Reports.
• Conduct various SQL Server Management Studio 2005/2008 tasks to manage and deploy packages in production environment.
• Execute ETL Packages using SQL Server Agent during night time and over the weekend.
• Involved in creating tabular and parameterized reports.
• Closely worked with different management levels to understand business rules and analysis needs.
• Used SQL Server 2005/2008 Reporting Services to build different types of reports, for instance, a report which shows Average Investment per Region.
• Wrote Joins, Store Procedures queries to retrieve the datasets for Report Designer.

Environment: SQL Server 2005/2008 (Management Studio, Integration Services, Reporting Services, and Analysis Services) T-SQL, MS Visio, MS Office SharePoint Portal Server 2007 and Windows Server 2003.

Confidential, Tuskegee, Al

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in collecting and analyzing several user requirements during the System Development Life (SDLC) process.
• Framed data design and develop data models (physical/logical data models) based on the given specs and requirements.
• Performed complex querying in T-SQL, wrote Stored Procedures, Triggers, and Queries with high performance execution plan.
• Used several Joins and Sub-Queries to complete complex queries involving multiple tables.
• Applied Common Table Expressions (CTE’s), Constraints, and Complex queries to fetch the data from different servers.
• Perform T-SQL queries for building user defined functions (UDF), views, indexes, user profiles, relational database models, data dictionaries, database constraints and data integrity.
• Used SSIS tool to extract data from Excel, CSV, OLE DB sources, used multiple transformations to transform the and finally load it to the SQL Server Data Warehouse and Data Marts.
• Produced different SSRS Enterprise reports from SQL Server Database (OLTP) and SQL server Data Marts (OLAP).
• Encompassed various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Performed several Parameterized Reports (SSRS 2005/2008) like standard parameter reports.

Environment: SQL Server 2005/2008/2008 R2 (Management Studio, Integration Services, Analysis Services, and Reporting services), ETL, MS Access, Excel, Windows Server 2008.

Confidential, AL

ETL Developer/Data Mining/Research Assistant

Responsibilities:

• Collect Data, Research Requirements, Reviewed Modeling, and System Analysis.
• Participated in the overall SDLC including the Planning, Analysis, Design, Testing and Implementation.
• Used Rational Requisite Pro 2001 to trace requirements and analyzed these requirements as outlined in the Requirement Specification document.
• Used MS Visio 2003 to develop Use Case Diagrams, Class Diagrams, Activity Diagrams, and Sequence Diagrams.
• Developed the Entity Relationship Diagram (ERD) using ER assistance tool to design the Data Mart (Star Schema).
• Extract the data from different sources (XML, Flat Files, MS Access 2003 and MS Excel 2003)
• Applied control flow tasks such as XML Task, Execute SQL Task, Execute Package Task, Data Flow Task, Script Task, and Containers (For-Each Loop and Sequence)
• Applied various types of transformation tasks (OLE DB Command, Look Up, Fuzzy Look Up, Data Conversion, Merge Join and SCD) of SQL Server 2005 Integration Services (SSIS) and finally execute the package to populate the dimensional model.
• Debugged the SSIS packages for error using different techniques.
• Create a Job to run the package at specific time (once a month) and used Type 1 SCD to upgrade historical data.
• Develop a Data Mining Model (Microsoft Decision Trees Algorithm) to see if there is a relationship and trends.

Environment: SQL Server 2005 (Management Studio, Integration Services, Analysis Services and Reporting services), T-SQL, Rational Requisite Pro 2001, MS Visio 2003 and Windows Server 2003/2005.