SUMMARY

• 9+ years of IT experience in analysis, design, implementation & administration of Business intelligence solutions with Microsoft SQL server 2014/2012/2008 R2/2005/2000 in development, Testing & production environment.
• Ability to deliver comprehensive Business Intelligence solution through integration of BI suite of products (SSIS, SSAS, SSRS, TABLEAU, Power BI) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Expert in RDBMS concepts, Data warehousing concepts, Star and Snow Flake, OLTP & OLAP.
• Strong Experience in various Extracting, Transforming and Loading (ETL/SSIS) data flow and Low Latency ETL using SSIS.
• Excellent in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, CDC, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
• Expert in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Excellent SQL Server Administration skills including Replications, Clustering, Always On, Mirroring, Log Shipping, Backups, Restore, database maintenance, user authorizations and Database creation.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Thorough understanding of Kimball/Inman strategies, KPI, Data mining structures.
• Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Scrum Master, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

• Microsoft SQL Server2008/R 7.0 2012/ R2
• SQL Server Integration
• Reporting & Analysis Services (2008/R2 2005 & 2000)
• Agile
• Scrum
• Water Fall
• PowerBI
• Sybase ASE 15.0
• Sybase IQ 12.7
• Oracle 10g/9i
• IBM DB2
• Teradata Studio Express 14.0
• T-SQL
• MYSQL
• CDC
• C#
• UNIX
• MDX
• PL-SQL
• MS SQL Profiler
• Putty
• Power Shell 2.0
• Excel Macro
• SQL Server Job Agent
• Idera 8.0
• Lite Speed 6.1
• Database Tuning Advisor
• Index Tuning
• SQL Query Analyzer
• MS Visual Studio 2005/2010
• MS Visio
• Erwin Data Modeler
• Tableau
• Crystal Reports 10/9
• Rational Rose
• Windows 2000
• 2003 & 2008 Advanced Server
• Visual Source Safe
• MS Access
• .NET
• HTML
• XML
• Excel PowerPivot
• OLAP
• OLTP
• Talend 4.2
• ADO.Net
• AccuRev 5.2c
• Epiphany 7.0/10.0.

PROFESSIONAL EXPERIENCE

Confidential, NH

MS SQL BI Developer

Responsibilities:

• Lead the BI team to Develop Data Warehouse, ETL data, Analysis and generate Reports.
• Design, develop and modify the Data Warehouse dimensional model as per the business requirement.
• Worked as a Scrum Master to arrange scrum meetings to make sure each sprints were accomplished in a timely manner.
• Created entire application using Python, Django, MySQL and Linux
• Performed SSAS (Analysis services) functions like calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.
• Created calculated measures based on business requirement and created/deployed SSAS cube.
• Used MDX queries to retrieve data from OLAP cubes to the SSRS reports.
• Created SSIS 2014 ETL Packages to load Dimensions and Fact tables in Data Warehouse daily.
• Created various SSRS 2014 Reports like Drill down, drill through and sub reports for Senior Manager and Financial Representatives.
• Implemented new SSRS 2014 features like visualizations in tables, matrices, and charts.
• Successfully implemented Agile methodology with Business IntelligenceTeam.
• Configured GitHub to use as a source control for Visual Studio 2013 and SSMS 2014 and as a Sprint tracking.
• Created T-SQL queries, stored procedures, user defined function and views, for faster retrieval of data by using T-SQL queries and to display specific information.
• Scripted Transact SQL (T-SQL) queries and used SQL Server Constraint (Primary Key, Foreign Key, Default, Checks and Unique)
• Wrote and executed various MYSQL database queries from python using Python-MySQL connector and MySQL dB package
• Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year ver Year Growth, YTD Total, and YTD Growth).
• Tested new SQL Server 2016 PowerBI feature and submitted feedback to the client.
• 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.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Converted Linux FTP process to SSIS and added encryption via WinSCP for daily reports.

Confidential, Houston, TX

Sr. SQL Server SSIS Developer

Responsibilities:

• Provided custom solutions for their ongoing ETL process for bug fix and enhancements.
• Developed a Conceptual model using CA Erwin r7.1 based on requirements analysis.
• Created advanced dynamic Archive and Purge process with BCP and SSIS.
• Provided 24x7 on-call support for their production processes and maintenances.
• Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database.
• Performed T-SQL tuning and optimization of queries using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008
• Created table reports, matrix reports, parameter reports and dashboard reports for fundraising department and business development department using SSRS 2012 and Tableau.
• Developed, Designed and Supported interactive Tableau Dashboard reports.
• Extensively used various views in Tableau like Tree Maps, Heat Maps, and Scatter Plots etc.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL
• Implemented Binning and Blending concepts in Tableau reports.
• Developed complex queries using dynamic sql, utilized query plans to identify bottlenecks.
• Performed day to day DBA tasks such as Backup, restores, shrink log files performance tuning etc.
• Upgraded SSIS projects/packages from SQL and from .
• Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries

Confidential - Horsham, PA

Sr. SQL Server Developer

Responsibilities:

• Upgraded SQL Server 2008 R2 databases to SQL Server 2012 version for Dev, QA, UAT and Prod environment.
• Upgraded SSIS 2008 ETL packages to SSIS 2012 version.
• Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters.
• Extracted data from various sources and performed data blending.
• Mapped and Customized OLLI, Faculty/ Staff, Parents master file imports and Developed T-SQL queries & Stored Procedures for Insert, Update and Delete to the tables based on the Customizations using SQL Server 2012.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Developed SSIS ETL packages and SQL Server stored, functions and tables to accommodate on-going data warehouse project.
• Managed all indexing, debugging, optimization and performance tuning using T-SQL.
• Created/Modified SQL Joins, Sub-queries and T-SQL code to implement Business rules
• Developed SSIS packages to process dimensions and SSAS cubes on daily basis.
• Implemented ETL Framework to streamline Logging, Error Handing and Email Notifications for all SQL stored procedures and SSIS packages and scheduled them in TWS scheduler.
• Created various Tableau reports for Insurance Claims, Plans and Premium using advance techniques like visualizations, drill down, drill through and sub reports.
• Experienced in Planning, Tracking, Releasing and Reporting through JIRA.
• Create ETL Technical Specification documents for existing and ongoing SQL Server stored procedures and SSIS packages.

Confidential, Dallas, TX

Sr. MS SQL Developer

Responsibilities:

• Provide 24x7 supports and streamline EOD (End of Day) Production process to ensure high availability and accuracy of data to end users and managers.
• Successfully replaced third party reporting application ‘eGlue’ with SQL Server, SSIS, SSRS and Excel.
• Responsible for Installation, configuration, maintenance, security, availability, backup/restore and upgrading of Microsoft SQL Server and related products.
• Reviewing and re-writing/re-building TSQL codes, SSIS packages and SSRS reports for performance improvement and logging in SQL Server 2012 R2.
• Having experienced in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts.
• Wrote PowerShell scripts to automate Excel Macros and generate various reports.
• Responsible for all functions associated with the design, implementation and maintenance of SQL Server databases including security, back up, logging, reporting and recovery procedures.
• Proactively monitor and profile production database servers for load and performance bottlenecks and provide solutions for query optimization and performance tuning.
• Implemented data warehouse in SSAS MOLAP cube with Facts, Measures and Dimensions.
• Created ETL package to process SSAS cube on a daily scheduled.
• Implemented KPIs, Relationships, and Calculated members in SSAS Cube.
• Created daily email reporting system for yesterday’s production and other job summaries along with database monitoring report specifically for space management.
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
• Designed and implemented Disaster Recovery Plan for Production and source servers.
• Imported Hadoop data using SSIS and Microsoft HDInsight into SQL Server.
• Added control tables based functionality in SSIS packages in order to re-run the package at any given point.

Confidential, Mahwah, NJ

SQL Server DBA Developer

Responsibilities:

• Responsible for Administration and Development of SQL Server Environment.
• Responsible for the development of ETL/SSIS Packages, SSRS Reports and T-SQL objects like stored procedures, triggers, indexes and functions.
• Worked with Business Solution team to understand and determine scope for different projects.
• Extensively Implemented SSIS auditing, error handling, and email error messaging.
• Migrated BLOB data from Cassandra into SQL Server.
• Performed customization and configuration work on OLTP databases, tables, stored procedures, SSIS packages and other objects.
• Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLookup and formulas, built PivotTables and Pivot Charts using PowerPivot skill.
• Extensively used dynamic approach to SSIS packages for the re-usability/modifications.
• Created MOLAP cubes for SSRS report in SSAS.
• Understood the business requirements from FSDs provided by the Business Solution Team and developed ETL job, SSRS Reports and SQL Server Objects.
• Participated in reviews of issues related to SSIS Packages/SSRS reports and work in troubleshooting those issues, fixing, testing and re-deploying them.
• Understood the broker dealer business functions and the context of the data warehouse project of company.
• Design and implemented commission, Pershing, license and registration and Albridge data flow to DW using SSIS with various advance technique.
• Worked with the business to understand the scope of the data warehouse an implemented business rules in ETL (SSIS) and OLTP systems.
• Written various stored procedures and functions, user defined datatypes to feed data in UI application.
• Successfully implemented CDC to capture/track changes in various tables.
• Developed ETL (SSIS) to extract, transform and load raw trade data coming from various clearing houses and sponsor companies to data warehouse.
• Involved in developing ETL (SSIS) to Transform data from raw feeds and load into flat file, which were further exported for commission processing.
• Performed SSAS (Analysis services) functions like calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.
• Created calculated measures based on business requirement and created/deployed SSAS cube.
• Used MDX queries to retrieve data from OLAP cubes to the SSRS reports.
• Extensively used Excel PowerPivot and Slicing and Dicing concept.
• Robust MS Access and Excel skills with PowerPivot, PivotTable, Pivot Chart, Power View, VLOOK UP functions and formulas,
• Worked with the Data analyst in understanding the development of reports from the create report models.
• Create documentation for the existing reports as well as new reports to be created.
• Understand business requirements from the specifications and develop reports based on them.
• Scheduled SSIS packages and T-SQL scripts using SQL Server Job Agent.
• Created and updated complex Stored Procedures, Triggers and User Defined Functions for logical T-SQL implementation.

Confidential, Houston, TX

SSIS/ETL Developer

Responsibilities:

• Successfully migrated ETL (SSIS) jobs from Talend Open Studio 4.2 to SSIS 2008.
• Designed various Mappings (Source-to-Target) using SSIS to link between different
• OLTP Source Systems and different Data warehouses for loading data into Warehouse.
• Created SSIS projects and imported all user roles and responsibilities.
• Imported metadata from sources like DB2 and flat files.
• Analyzed existing logical data model (LDM) and made appropriate changes to make it
• Compatible with the business requirement.
• Involved in modeling the Star Schema, Data Warehouse by identifying the facts and dimensions using Erwin Data modeling tool.
• Analyzed data discrepancies through Error and Log files for further data processing and cleansing.
• Involved in design phase meetings for Business Analysis and Requirements gathering.
• Developed conversion and migration strategy in collaboration with functional business lead.
• Reviewed and implemented the naming standards for the ETL (SSIS) processes, packages, transformations etc.
• Documented migration approach document from Talend OS 4.2 to MS SQL Server SSIS 2008.
• Designed and documented DataStage ETL (SSIS) Standards and Best Practice document.

Confidential

SQL Server DBA/ETL Developer

Responsibilities:

• Worked with project lead, analyst, and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Highly responsible for development and management of SSIS, SSAS and SSRS projects.
• Developed ad-hoc queries and reports for unit team lead as requested and provide on-going analytical support for these requests.
• Formulated and documented the physical ETL (SSIS) process design based on business requirements and system specifications with strong ETL (SSIS) design skills, including source (OLTP) to target mappings, transformations, lookups, aggregations, expressions.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
• Created Projected Income Statements and other Financial Reports. Developed yearly and quarterly expense reports.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using sql server reporting services(SSRS).
• Designed and developed report with Running value, interactive sorting as well as conditional formatting.
• Experience on created reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports.
• Built SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Created sub-reports to present more detailed information about the summary.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.

Confidential

MS SQL BI (SSRS/SSAS) Developer

Responsibilities:

• Gathering, project analysis & review meetings and progress reporting.
• Advised Development team on the development of SSIS packages for various inbound/outbound data, OLAP system as well as large volume Data warehouse.
• Built packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping.
• Developed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.
• Created SSRS Report Model Projects in BI studio as well as created, modified and managed various report models with multiple model objects, source fields and expressions.
• Experienced invery complex project of designing Decomposition Tree View of SSAS cube in ProClarity Analytics Server and used it as a part of PPS Dashboard with multiple Roll Confidential & Calculations.
• Involved with the Project Analyst via peer reviews and code inspections to ensure code meets the business and system requirements.
• Worked with other developers to ensure the code interdependencies are met and fully tested via a formal system test plan.