SUMMARY

• Over 8 years of Experience in Development, Implementation and Reporting in MS SQLServer 2014/2012/2008 R2 with Business Intelligence in SQLServer Integration Services (SSIS),SQLServer Analysis Services (SSAS) andSQL Server Reporting Services(SSRS).
• Hands on Experience SQL Server Integration Services (SSIS) andSQLServer Reporting Services (SSRS) with good knowledge onSQLServer Analysis Services (SSAS).
• Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects and worked in Agile Methodology.
• Experience in schedulingSSISpackages using SQL Server Agent.
• Experience in modelling Transactional Databases and Data Warehouse using tools like Erwin, Oracle Designer, Power Designer and ER/Studio.
• Excellent understanding of Relational Database Systems (RDBMS), Normalization, Multi - Dimensional (Star) and Snowflake logical and physical data modelling using ERWIN data modeler and MSVISIO
• Experience in creating reports such as Parameterized, Cascading, Drill through/Drill down Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
• Proficient in OLTP, OLAP and Data warehousing Design concepts
• 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.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database
• Used DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes
• Experience in Relational, Multi-Dimensional (Star) and Snowflake logical modelling.
• Experience in creatingPower BIdashboards/reports using tabular models and good in managing Gateways and content packs.
• Explore data in a variety of ways and across multiple visualizations usingPower BI.
• Created reports in Power BIpreview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in publishingPowerBIDesktop reports created in Report view to thePowerBIservice.
• Performed Data Migrations fromTableau6 toTableau7.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQLProfiler, and Windows Performance Monitor for optimal Performance.
• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).
• Experienced in Agile Methodologies like attending daily Scrums, maintaining User Stories and Burn down Charts, Backlog Grooming and Retrospective.

TECHNICAL SKILLS

Operating Systems: Windows (All Versions) Unix, Linux, Mac

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , MS Access, Oracle 8i & 9i, Sybase, MS Access 97/2000/2003/2007 , MYSQL.

Database Design Tools and Data Modeling: Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snowflake Schema, Extended Star Schema, Physical And Logical Modelling, Dimension Data Modelling, Fact Tables, Dimension Tables, Normalization, Denormalization, MS Visio.

Modelling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modelling, ER Diagrams

BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Reporting Services (SSRS 2005/2008/2012 ) SQL Server Analytical Services (SSAS 2005/2008/2012 ), Data Transformation Services (DTS), Visual Studio, BIDS, Power BI, Tableau.

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, IIS 6.0/7.0, Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest, Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2.

Languages: C, C++, HTML, XML/XSLT/.Net/C#, Core Java, Python,VB.NET

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, Iowa

SQL Developer/Power BI Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Involved in database development using stored procedures, triggers, views and cursors.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.
• Collaborated with senior management, subject matter experts, and IT teams to define business requirements
• Transformed business requirements into functional and non-functional requirements.
• Created complex stored procedures to perform various tasks including, but not limited to: index maintenance, data profiling, metadata searches, and loading of the data mart.
• Designed, developed, and tested the ETL strategy to populate data from multiple source systems.
• Implemented SSIS packages to perform ETL data messaging operations (data profiling, cleansing, and verification).
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Recommend best of breed customer solutions, based upon existing products and/or custom work.
• Standardized reports based on the customer needs and provided best value to our end customer.
• Provide SQL scripts enhancement in the existing reports and improve system performance to handle growing amount of data while minimizing load on application servers in production environment.
• Developer prototypes and frameworks.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Optimized report performance with caches and snapshots.
• Proactively resolve issues to drive quality and system performance improvements across the application
• Participate in cross-team information sharing resources and work to identify risks early in the development process
• Implemented TFS for project version control and change management with bug tracking.

Confidential, Fort Lauderdale, Florida

SQL BI/Power BI Developer

Responsibilities:

• Extensively worked on Dimensional modelling, Data cleansing and Data Staging of operational sources using ETL processes.
• Created tables, views, stored procedures, functions in SQL Server 2016.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Created jobs, alerts using SQL Server Agent to run SSIS packages periodically.
• Designed and developed Power BIgraphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Created MDX and DAX Queries from Tabular model for SSRS Reports.
• Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modelling, Snow-Flake Modelling, Fact, and Dimensions Tables using MS Analysis Services.
• Writing complex DAX functions inPower BI.
• Managed relationship between tables in Power BI using star schema
• Implemented real-time responsive reporting solutions withPower BI, by connecting to the SQL Server database through On-Premise Gateway also used DAX for doing calculated measures and for creating new columns.
• UtilizedPower BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them usingPower BI to the decision makers for strategic planning.
• Implemented complex DAX calculations for SSAS 2014 Tabular Responsibilities model
• Strong knowledge in Databases, Data warehouse concepts, ETL process and Business Intelligence.
• Worked in Agile Scrum Methodology with daily stand-up meetings.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created calculated measures in tabular model using DAX Queries according to end user requests and reporting needs.
• Modified ongoing reports for better understanding using charts and pivot tables usingExcel
• Created Tabular Models using DAX queries in analysis services and deployed it.
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.

Environment: MS SQL Server 2016 R2, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS 2015), SQL Server Analysis Services (SSAS 2015), SQL Server Reporting Services (SSRS 2015), Power BI,Power Pivot, Windows 2010, MS Excel, SQL Server Profiler.

Confidential, Omaha, NE

SQL BI Developer

Responsibilities:

• CreatedSSISpackages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse..
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.
• Wrote efficient Stored Procedures for the Optimal Performance of the system.
• 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 inSSISDesigner
• ScheduledSSISpackages for running monthly and weekly feeds from various guarantors and multiple servers.
• Involved in enhancing and deploying theSSISPackages from development server to production server
• Established ETL design practices for optimization and performance of packages and ParameterizedSSIS.
• Create low level design and ETL design doc according to requirement.
• Analyse existing ETL jobs and find the gaps
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.

Confidential, Grand Rapids, MI

SQL Developer/ETL Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Involved in database development using stored procedures, triggers, views and cursors.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.
• Wrote efficient Stored Procedures for the Optimal Performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Extensively involved in designing the SSIS packages to export data from flat file source toSQL Server database.
• Created jobs, alerts using SQL Server Agent to run SSIS packages periodically.
• Used check point, break point and Logging in SSIS to debug and optimize package while developing them
• Used Event Handlers to run the Send mail task in the background upon failure of SSIS package.
• Developed SSIS packages using various transformations such as conditional splits, fuzzy look ups, aggregations and multicasting
• Pulling data daily from OLTP database to OLAP or staging database using the SSIS packages.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Implemented real-time responsive reporting solutions withPower BI, by connecting to the SQL Server database through On-Premises Gateway also used DAX for doing calculated measures and for creating new columns.
• Implemented complex DAX calculations for SSAS 2014 Tabular model
• Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI.
• Worked on Power Query in Power BIdesktop to edit the queries and Model for data modelling and establishing the relationships.
• Worked on Power BIservice by publishing the Power BIreports onto Power BIserver and collaborated team using Power BIservice to create the dashboards.
• Created hierarchies in Power BIreports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data in to Power BIfor creating reports.

Environment: Windows OS 2012, MS SQL Server 2008 R2/2012, Visual Studio 2008/2012, SSRS, SSIS, SSAS, MS Office, PowerBI, Power Pivot.

Confidential, Tempe, AZ

SQL BI/ETL Developer

Responsibilities:

• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Written complex T-SQLstatements (Queries) for retrieval of data and involved in performance tuning of T-SQLqueries
• Involved in designing of initial package, keeping in view implementing appropriate SSIS controls.
• Scheduled the job to do this task periodically creating and modifying T-SQLstored procedures/triggers for validating the integrity of the data.
• Designed SSIS packages to migrate the data from DB2, flat files, excel documents and CVS files to the Staging Area in SQL Server
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS
• Extensively involved in designing the SSIS packages to export data from flat file source toSQL Server database.
• Extensively worked onviews, cursors, CTE’s, schemas,permissions and performance issues with client/server database design.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS
• Developed SSIS packages using various transformations such as conditional splits, fuzzy look ups, aggregations and multicasting.
• Implemented SQL server 2014 latest features like Project level Deployment, Project Parameterization, GUID etc.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Responsible for creating SQL datasets for Power BIand Ad-hoc Reports.
• Created, Maintained & scheduled various reports in Power BIlike Tabular Reports, Matrix Reports.
• Created Tabular Models as a source toPower BIdashboards and scheduled jobs to refresh it in a timely manner.
• Developed and maintained multiplePower BIdashboards/reports and content packs.
• Made changes to the existingPower BIDashboard on a regular basis as per requests from Business.
• PublishedPowerBIDesktop reports created in Report view to thePowerBIservice.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BIreports.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
• Implemented Data discovery and created an application that uses heat-maps and geographical maps for finding patterns.

Environment: MS SQL Server 2012/2014 R2, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS 2014), SQL Server Analysis Services (SSAS 2014), SQL Server Reporting Services (SSRS 2014), Power BI, Windows 2010, MS Excel, SQL Server Profiler.

Confidential

SQL BI Developer

Responsibilities:

• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• Written stored procedures and SQL scripts in SQL server implement business rules for various clients
• Written T-SQL queries for the retrieval of the data.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and debugging T-SQL, stored procedures, views and user defined functions.
• Data migration (import & export - BCP) from text to SQL Server.
• Developed administrative tasks of SQL server of performing daily backups and recovery procedures.
• Error handling using Try-Catch Block.
• Installed and configured SQL Server 2005 with latest service packs.
• Customized the stored procedures and database triggers to meet the changing business rules.
• Implemented indexes for performance tuning.
• Worked with the developing team in the writing functions in Visual Basic 6.0 for upload download functionality, data transfer and migration.
• Prepared daily and weekly status reports and collaborated with other team members.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, triggers and maintained referential integrity.
• Involved in gathering business requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2005.
• Analyzed the existing data and performed the migration steps to SQL Server 2005.
• Performance testing on Store procedures, Indexes.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Developed complex stored procedures, triggers, cursors, tables, indexes, constraints, views and other SQL joins for applications.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Environment: Windows server 2007, IIS 5.0, MSSQLServer 2012/2008R2, Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS,SQLProfiler, DB2, Hive, Erwin VB.NET, OLAP, OLTP, Performance Point Sever, MS Excel