SUMMARY

• Around 8 years of Information Technology experience in all phases of Software development life cycle including Database administration, Data Analysis and Business Intelligence.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T - SQL.
• Extensively worked with clients to understand business requirements, recommended technical solutions and documented functional requirements.
• Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, Data Vault Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Experience in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology and Agile methodology.
• Strong experience in design and developing ETL using SQL Server Integration Services (SSIS).
• Experience in creating SSIS package to load data from Flat Files to SQL Server using various types of transformations like Lookup, Fuzzy Lookup, Multicast, Derived Columns, Condition Split, Term Extraction, Aggregate, for transferred data modifications and dataflow tasks, script tasks, for loop container, for each loop, sequence container and Slowly Changing Dimension.
• Experience in Installing, Managing, Monitoring and Troubleshooting SQL Server.
• Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS) generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS.
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key, Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Developed advance complexed scalable ETL SSIS solutions utilizing Microsoft Azure Service Bus, Web Services (Rest and Web API), and Microsoft Stream Insight Server Platform
• Expertise in generating reports on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services, Crystal Reports, MS Excel, Power BI and Tableau.
• Configure database replication from on premises to Azure SQL, data sync and migration of database to and from Premise/Azure DB.
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, Excel, CSV, MS access and flat files.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Experience with logical and physical data modeling, Fact and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Very good Self-motivated, smart working Professional with good organizational leadership.
• Ability to work in-groups as well as independently with minimal supervision.

TECHNICAL SKILLS

Databases: MySQL, MS SQL Server (2008.2008R,2012,2014,2016), Oracle (10g,11g,12c), MS Access, IBM DB2, Mongo DB

Languages: SQL, T-SQL, PL/SQL, R, SAS, Python, UML, Java, HTML, CSS

Tools: SQL Server Management Studio (SSMS), MS Visual Studio (2013/2015/2017 ), Eclipse, SQL Server Profiler, Power BI (Desktop, Server, Mobile), MS Excel, MS Word, MS Project, MS Visio 2016, SQL Plus, Tableau (Desktop, Server).

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) Import Export Data, Alteryx

Methodologies: Waterfall, Agile, Business Analysis, Object-Oriented (Use Case) Analysis, Database Design and Normalization, Data Modeling.

Machine Learning: ANOVA, Regression (Linear, Logistic, Polynomial, Decision Tree, Random Forest, Support Vector), Naïve Bayes, K-NN, Clustering (Hierarchical, K-Means)

Big Data Technologies: Hadoop, Pig, Hive, Oozie, Flume, Impala, Avro, Kafka, Spark

Operating Systems: Windows Server 2003R2/2008R2/2012, Windows (XP,7,10), Unix.

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Power BI developer

Responsibilities:

• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
• Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.
• Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
• Imported custom themes and page backgrounds for rich visual effects.
• Performed end to end testing on the reports and packages developed to ensure data quality is met.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
• Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2, Salesforce and Intacct.
• Created many calculated columns and measures using DAX in Power BI based on report requirements.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.

Environment: MS SQL Server 2014/2012/2008 , Visual Studio 2010/2012, Tableau, Reporting Services (SSRS), Power BI, Integration Services (SSIS), Analysis Services (SSAS), T-SQL, Microsoft Azure, Excel.

Confidential, Irving TX

SQL/Power BI developer

Responsibilities:

• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Gathered the functional requirements from the client.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Developed SSIS packages using for Each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Used various SSIS tasks such as Conditional Split, Derived Column, Lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes using dimensional modeling standards in SQL server.
• Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Simultaneously maintained the existing ETL and recreated new SSIS packages and created test cases for testing the SSIS packages.
• Wrote complex SQL queries and stored procedure to create reports using SSRS from the relational database.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Created SSRS Data Model projects using Microsoft Visual Studio and using Report Builder for report server to create reports.
• Developed and maintained system documentation, diagrams and flowcharts.

Environment: SQL Server 2008R2/2012, SSIS, SSRS, SSAS, T-SQL, MS Office (Word, Power point, Excel), ETL, Microsoft Visual Studio, Power BI, TFS, ERWIN, SharePoint .

Confidential, Houston, TX

SQL/BI Developer

Responsibilities:

• Created stored procedures and user defines functions to support efficient data storage and manipulation, handling database objects with Enterprise Manager and provided Technical Documentation for future enhancements.
• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Developed data access queries/programs using SQL Query to run in production on a regular basis.
• Created Triggers, Cursors, Tables, Views, Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Identified various data sources, formulated data dictionaries, design and develop data models (Physical/ logical data models) based on the given specs and requirements.
• Scheduled and maintained packages by daily, weekly and monthly basis using SQL Server Agent in SSMS and involved in 24*7 production support.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Experience in end-user reporting definition, development and platform support using SQL Server Reporting Services (SSRS) and Performance Point.
• Performed ad hoc queries, design and deployed reports using SSRS and resolved any issues related with it.
• Extensively used Report Builder and Report Manager in SSRS.
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Performed tune to optimize SQL queries using SQL profiler and responsible for performance tuning of the database.
• Schedule meetings and coordinate between team members for the progress of the projects

Environment: s: T-SQL, SQL Server 2005/2008/2008 R2/2012/2014, MSBI BI Suite (SSIS, SSRS), MS Power point, MS Project, MS Visio