PROFESSIONAL SUMMARY:

• Over 6 years of IT experience in Database Development using SQL Server, BI tools such as SSIS, SSRS, Power BI, and SSAS as SQL Developer and MSBI Developer.
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Knowledge in Normalization/De-Normalization and Data Modeling. Worked on tools such as Erwin, SQL power architect to create and reverse engineer ER diagrams.
• Worked on creating indexes, re-build indexes and improving performance in query tuning.
• Experience in developing tables, user-defined functions, stored procedures.
• Worked on various Isolation Levels, Error Handling, CTEs, Merge statements using SSIS
• Developed SSIS solutions for ETL and Business Intelligence process for Data Integration and Migration Services.
• Expert in development and deployment of SSIS packages from various sources like MS Access, Oracle, Excel, Microsoft SQL Server, flat file, and XML.
• Developed ETL process using SSIS with various Control flow, Data flow tasks and Stored Procedures for the work order validation process.
• Worked in SSIS Packages using various transformations like Lookups, Fuzzy Look-ups, Aggregate Functions, Merge Join, Conditional Split, Data Conversion, Derived Column etc.
• Experience in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS packages.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like Linked, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Document Map and Sub-Reports.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub-reports, and formatting them.
• Expert in creating and developing Power BI Dashboards and configuring data gateways to have automatic refresh of the data.
• Import data from different data source to create Power BI reports and dashboards.
• Involved in creating dynamic, well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling
• Experience in calculating measures and dimension members using the Multidimensional Expression (MDX), mathematical formulas.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2014/2012/2008 ), Power BI, Tableau

Database: MS SQL Server 2014/2012/2008/2005 , MS Access, Oracle, MySQL

TSQL, PL: SQL, Python

Web Technologies: HTML, DHTML

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), Illustrator, Abode Flash, Mac Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

SQL/MSBI/POWER BI Developer

• Designed SSIS packages to extract data from various data sources such as Access Database, Excel spreadsheet and Flat files into SQL Server for further Data Analysis and Reporting by using transformation in SSIS such as Data conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Created packages in SSIS with Error Handling and worked with different methods of logging in SSIS.
• Created complex reports using multiple data providers, user defined objects, charts and synchronized queries.
• Involved in creating dynamic well-organized, accurate an insightful Power BI reports/dashboard to support strategic decisions.
• Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.
• Created Indexes, Views, Stored Procedures, User Defined Function, Cursors and Triggers to facilitate efficient data manipulation and data consistency.
• Performed Query optimization and performance tuning of Stored Procedures and Functions.
• Partitioning of tables to increase in performance and availability of data.
• Worked on providing row level securities using power bi to restrict data access for various users.
• Involvement in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decision making.
• Expertise in publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server.

Confidential, Oakbrook Terrace, IL

SQL/MSBI/POWER BI Developer

• Planned, designed, and implemented application database code objects, such as tables, stored procedures, functions and views in partnership with business analysts and technical architects.
• Implemented complex business logic and processes through T-SQL stored procedures, Functions, Views and advance query concepts.
• Collaborated and coordinated with business analysts to gather requirements for implementing data mart.
• Created required SQL procedures, functions, triggers, and views to supports OLTP and ETL application.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2005/2008.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Extracted data from database and export to Excel files for Data Analyst to analyze the data.
• Scheduled Packages using SQL Server Agent Jobs to execute at specified time on weekly and monthly basis.

Confidential, Denver, CO

SSIS/SSRS/MSBI/POWER BI Developer

• Involved in database design and development in DB2 to SQL Server migration.
• Created various complex queries that involves multi-tables joins, union, sub-queries to match destination design.
• Involved in creation of Indexes, Stored Procedures, Triggers, Views, and Functions.
• Designed SSIS packages using Sequence containers, Data Transformation for initial load from DB2 to SQL server.
• Scheduled SQL Jobs and SSIS packages using SQL Server agent to sync data from DB2 module to SQL server.
• Worked on troubleshooting and debugging recurring and ad-hoc issues with queries, SSIS packages.
• Involved in Scheduling, Backups, Restoration and Log Backups.
• Created stored procedures to scrub and mask data to be available for development and production environment.
• Reviewed and resolved T-SQL issues using management studio for better performance.
• Deployed SSIS packages from multiple environments.
• Involved in performance optimization of SSIS packages.
• Generated and scheduled Reports by writing Stored Procedures according to the business need.
• Monitored growth of database objects for capacity planning.
• Developed DTS Packages to get the reports, routinely, in the excel sheets, required by the managers for analysis.

Confidential

SQL Developer

• Planned, designed, and implemented application database code objects, such as tables, stored procedures, functions and views in partnership with business analysts and technical architects.
• Implemented complex business logic and processes through T-SQL stored procedures, Functions, Views and advance query concepts.
• Collaborated and coordinated with business analysts to gather requirements for implementing data mart.
• Created required SQL procedures, functions, triggers, and views to supports OLTP and ETL application.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2005/2008.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Extracted data from database and export to Excel files for Data Analyst to analyze the data.
• Scheduled Packages using SQL Server Agent Jobs to execute at specified time on weekly and monthly basis.