SUMMARY

• Around 8 Years of Extensive Experience in Business Intelligence Applications Design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Experience in creating/deploying Data Transformation Services (DTS), Knowledge of Integration Services (SSIS) packages, and Reporting Services (SSRS).
• Expertise in Extraction, Transformation, loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Strong Experience in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, Joins, triggers, clustering, T - SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), relational database models, data dictionaries, and data integrity.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Created, Maintained & scheduled various reports in Power BI.
• Published Power BI reports from Power BI desktop to Power BI service.
• Created different visualization in Power BI according to the requirements.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
• Experience in Cube designing in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in Designing, Building the Dimensions, cubes with star schema, snowflakes schema.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2005/2008 Analysis Services.
• Experience in creating Report Models for building Ad hoc reports using SSRS.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Very good experience in writing expressions in SSRS.
• Excellent experience in developing complex Stored Procedures, Views and Indexed Views.
• Good knowledge in RDBMS concepts, Data warehousing concepts, & OLAP.
• Worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema and Entity relationship diagrams from business requirements.
• Good experience in creating User Defined Functions and Triggers in observing Business Rules.
• Expertise in working with Version control system (VSS, VS, TFS)
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Proficient in implementing surrogate key generation strategy in the Data warehouse.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSRS, Data Transformation Services, Scope, Tableau, Power BI.

RDBMS: SQL Server 2008/2005/2000 , 7.0, MS-Access.

Languages: C, C#, T-SQL, PL/SQL, JavaScript, Perl, Cosmos.

Web Technologies: Share point, HTML, CSS, XML, JavaScript, PHP, Shell Scripting.

Version Control: Visual Source Safe, Clear Case.

Data Modeling: Erwin r7.3/7x/4.0, MS Office Visio 2003/2007.

Operating System: Linux, Mac OS X, Microsoft Windows/Advanced Server, MS-DOS, UNIX.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

SQL/ POWER BI Developer

Responsibilities:

• Interacted with the business users for understanding the business requirements and the existing system
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2016.
• Created the views in the intake-database for the MS Sales hierarchies to be use in the store procedures in Staging database.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Created many complex Query's and used them in Power BI Reports directly to generate reports on the fly.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Using SSIS Package identified the Up-streams and imported the required tables into intake-database, Store Procedures are created in staging database using the intake-database tables & views.
• Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
• Responsible for deploying the application for the Integration, Functional and User Acceptance Testing.
• Adheres to department, organization and industry guidelines, standards, policies and procedures.
• Create reports in Power BI preview portal utilizing the Tabular Model via Analysis connector.
• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
• Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
• Used One Drive for storing different versions of Power BI report.
• Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps.
• Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.
• Used JIRA for Version Control needs, task check-ins.
• Responsible for complete maintenance and delivery of scheduled releases.

Environment: MS SQL Server 2014/2016 T-SQL, MS SQL Integration Services 2014/2016,Power BI.

SQL BI/ETLDeveloper (SSIS/SSRS)

Confidential, Houston TX

Responsibilities:

• Requirements gathering from the business analyst and preparing POC documents for the design & development of BI solutions (ETL/Reporting)
• Using SSIS, loaded XML data to the Database tables and Extracting Data using SSIS into Excel Files for Marketing purpose.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.
• Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Created Crystal Reports with ole object extracting image file from the database and URL links
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements
• Written complex sql queries to retrieve data from Dynamic CRM and display in SSRS reports. CreatedSSIS job to verify accounts and leads from excel file
• Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and server efficiency SSRS and SSIS.
• Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSRS.
• Created automated stored procedures for day end operations using SQL server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using server Profiler and Index Tuning Wizard in SSRS and SSIS.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files.
• Customized the formatting of the Crystal Report using formula's at the section level.
• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
• T-SQL programming, Complex Query writing, Query Optimization and Database Tuning.
• Worked with DTS packages and MS OLAP Services.
• Converse implementation limitations and data driven solutions with all levels of the project team and management
• Maintained the consistency of the client's Database using DBCC.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.

Environment: SQLServer2012, 2008/2008 R2, Business Intelligence Studio (SSIS, SSRS), T SQL, Erwin, TFS, MDX, Oracle 10g, ProClarity, MS Excel.

SQL BI Developer (SSIS/SSRS)

Confidential, Houston, TX

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Involved in developing creative MS SQL solutions including Store Procedures, Views, Functions, User Defined Data Types, DTS/SSIS jobs, and job schedules assuring optimal functionality and adherence to corporate coding Specifications.
• Used ETL to implement the SCD transformation, to maintain historical data in data warehouse.
• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Understanding end user's proposed changes during client calls, analyzing and planning to in corporate the changes in the existing database.
• Deploying DTS/SSIS Packages and SSRS to generate reports to other non-prod environments.
• Expert in creating different formats of reports for internal and external reporting purposes and deploy them in Performance Point Server as well as SharePoint.
• Did research on leveraging database snapshots while performing deployments, did POC for that and brought pros and cons of using it before the team and eventually started using it in the production deployments and releases.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources and if the loading process breaks in between, resuming it from that point and logging after each step into the application Log database.
• Created a large number of stored procedures and used Common Table Expressions (CTE) and various kinds of User Defined Functions (UDF) in the stored procedures to make the code easy to understand and reliable.
• Used SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.

Environment: MS SQL Server 2008/2008R2, MS SQL Server Reporting Services, MS SQL Server Integration Services, ProClarity, C#, ASP.NET, VB.NET, OLAP, UML, Erwin, DTS/SSIS, BIDS

SQL Developer

Confidential, Blue Bell, PA

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Installed and Configured SQL Server 2005/2008 enterprise edition per client request.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005/2008.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in using different transformations like fuzzy lookup, derived column transformations etc in SSIS packages.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Perform unit testing at various levels of the ETL.
• Involved in creating different kinds of reports like tabular reports, matrix reports, sub-reports, drill down reports etc and deployed them to the report manager using SSRS.
• SSRS experience with extensive report development experience, dash boarding and development of cubes for reporting.
• Done performance tuning to optimize the run time.
• Changed stored procedures according to the new hierarchy.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.

Environment: SQL Server 20 R2, SSIS, SSRS, OLAP, OLTP, Erwin, Performance Point Server, SQL Server Business intelligence Development Studio (BIDS), T-SQL, VB.NET, ASP, ASP.NET, C#, MS Excel, Windows 2000 Server, T-SQL, MS Visual Studio.NET, Unix