SUMMARY

• 8+ Years of extensive IT experience as a Microsoft SQL Server Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS, MicroStrategy, Tableau and Power BI and expertise in designing and implementing Relational Database model as per business needs
• Worked with different domains like Insurance, Banking, Telecommunications, Shipping and HealthCare.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Functions, User Defined Datatypes, Rules, And Defaults for data consistency and manipulation.
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and Normalizations.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Experience in using SSIS Tools like Import and Export wizard, package Installation, and SSIS Package Designer.
• Experience in Importing/Exporting data between different sources like Oracle/Access/Excel etc. using SSIS utility.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Working experience on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Expert in handling parameterized reports in SSRS 2005/2008/2012.
• Experience in creating Multidimensional cubes using SQL Server Analysis Service (SSAS).
• Working on various RDBMS databases like SQL, Teradata, Oracle.
• Having good knowledge ofTeradataDatabase Architecture, Database Features andTeradatatools.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Power BI Desktop experience in designing Interactive Reports and Data Visualization.
• Assist end Users with problems installing the Power BI Desktop, Installing and configure the personal and On - Premises gateway, connecting to data sources and adding the different users and troubleshooting their row-level security for their company.
• Excellent backend skills in creating MicroStrategy Cubes, Reports, Documents and Dossiers.
• Worked extensively on VLDB Properties for performance tuning.
• Generated reports using Advanced Metric objects, Filters, Prompts and created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Excellent backend skills in creating, maintaining, and modifying Attributes, Metrics, Filters, Facts, Custom Groups, Prompts and Hierarchies.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Flexible, enthusiastic, and project-oriented team player with excellent communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000, 2003, 2008 and 2008R2. Unix, MS Windows (95, 98, NT, 2000, XP).

SQL Server and Database tools.: SQL Server 2008/2012/2014/2016. MSBI Tools - SSIS (Integration), SSRS (Reporting), SSAS (Analysis), Power BI, MicroStrategy, Teradata, Oracle.

Languages: MDX/DAX, VB.Net, VB Script, Transact-SQL, PL/SQL, HTML, DHTML, XML, ASP, C and C++.

Reporting Packages: SQL Server Reporting Services, Import Export Data, Bulk Insert, Business Objects 6.5/XI/XIR2, Crystal reports, MS Excel. Jasper reports, MicroStrategy Desktop 10.x/9. x. MicroStrategy Architect, MicroStrategy Web; MicroStrategy Intelligence Server; MicroStrategy Narrowcast Server.

Data Modeling and Configuration Tools: Erwin, MS Visio, Toad Data Modeler 5.1, QlikView suite, Power BI.

Methodologies: Agile, SCRUM, Waterfall.

Testing Tools: Quick Test Pro, Mercury Quality Center, TOAD (Tool for Application Developers).

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Optimized the performance of various SQL scripts, stored procedures, and triggers by using embedded UDFs, CTEs and System stored procedures.
• Monitoring SQL Server performance using SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Expertise level of knowledge as a data analyst in data conversion and data cleansing from the raw data sources.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Developed various functions using SQL Server 2008 for the interfaces which were automatically run on daily, weekly, and monthly basis using SQL server task in SSIS.
• Used ETL (SSIS) to develop jobs for Extracting, Cleaning, Transforming, and Loading data into data warehouse.
• Prepared the complete Data Mapping for all the migrated jobs using SSIS.
• Designed SSIS packages to transfer data from Flat files to SQL server using business intelligence development studio.
• Extracting queries from multiple databases like MS SQL, Teradata, and Oracle.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, Parameterized Reports in SSRS.
• Worked on Teradata insert, Update, modify and Dynamic SQL to transform and load Summary tables built on Core Data Warehouse.
• Extensively worked on Performance Tuning of Teradata SQL using explain plan and understanding Joins and Data distribution.
• Specialized in transforming data into user- friendly visualization to give business users a complete view of their business using Power BI.
• Designing Interactive Reports and Data Visualization using Power BI Desktop from multiple data sources such as MS SQL Server, Teradata, and Oracle.
• Developed and published reports and dashboards using Power BI and written effective DAX formulas and Expressions.
• Design, develop and implement MicroStrategy Cubes, Reports, Documents, Dashboards & Scorecard Reports based on agile stories using the MicroStrategy suite of tools.
• Create, maintain, and modify Attributes, Metrics, Filters, Facts, Custom Groups, Prompts and Hierarchies.
• Provide application support for IT-related issues in MicroStrategy reporting.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
• Become a SME on the client organization’s data, processes, and business methodologies.
• Provide proactive production support for Power BI, MicroStrategy and other BI/Analytics applications.
• This includes monitoring usage patterns and recommending improvements.

Environment: MS SQL Server 2008 R2, MS SQL SERVER 2014/2016, SSRS, SSIS, SSAS, Power BI, Power View, Visual Studio 2008, SharePoint, SQL Server Management Studio, ASP, Toad Data Modeler 5.1, Redshift, PostgreSQL, SAS Enterprise Guide 4.3, Teradata SQL assistant, MicroStrategy 10.x/9.x, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server.

Confidential, Louisville, KY

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Created complex ETL packages to extract data from staging tables to portioned tables with incremental load.
• Created SSIS reusable packages to extract data from multi formatted Flat Files, Excel, XML files into UL Databases and DB2 Billing system.
• Developed deployed and monitored SSIS packages.
• Wrote complex SQL queries using joins, sub queries, and correlated sub queries to retrieve data from the database.
• Created Data Mapping Document (DMD) by analyzing various OLTP data sources.
• Developed Reports, Views and Stored Procedures and deployed them on server using SQLServer Reporting Services (SSRS).
• Implemented Business Logic utilizing CTEs, Temporary Tables, Table Variables, Dynamic SQL and System / Aggregate / Ranking Functions.
• Scheduled reports for daily, weekly, and monthly reports; created reports for executives, business analysts, and customer representatives based on business needs.
• Tuned SQLQueries by Analyzing Execution plans, Reorganizing/Rebuilding Indexes.
• Experience in creating scheduling Jobs, Alerts.
• Setting up ODBC connections with Teradata, SAS, SQL servers on machine to extract data.
• Imported and exported data from other data sources such as Excel and Access.
• Worked on POWER BI to collect the data and update on the EXCEL reports as per the business requirement.
• Imported Data from Multiple data sources Teradata/SAS/SQL server which also includes Web files, MS-Excel through OLEDB and ODBC connections, Text, CSV files.
• Extensively worked on the Extraction, Transformation and Load (ETL) process usingPL/SQLto populate the tables in database.
• Worked closely with the Business Analysts to gain a good understanding of the specifications and timelines.
• Strong experience usingMicroStrategySuite (Intelligence Server, Desktop, MDX Adapter/ OLAP Provider, Web, Narrowcast Server, Visual Insight, Report Services).
• Involved inMicroStrategyReport Services by designing Documents, Creating Dashboards and Scorecards.
• Designed and created Reports from multiple data sources inMicroStrategy.
• Extended full support for the team regarding issues, feature discussions, and/or enhancements.

Environment: MS SQL Server 2008 R2, MS SQL SERVER 2014/2016, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), Power BI, Power View, Visual Studio 2008, SharePoint, SQL Server Management Studio, ASP, Toad Data Modeler 5.1, SAS Enterprise Guide 4.3, Teradata SQL assistant, MicroStrategy10.x/9.x.

Confidential, Seattle, WA

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Created SSIS Packages for loading the data coming from various interfaces like Orders, Adjustments and Objectives and used multiple transformation in SSIS to collect data from different sources.
• Worked on SSIS package, DTS Import/Export for transferring data from database (Oracle and Text Format data) to SQL Server.
• Extensively worked with SSIS Tool Suite, Designed, and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Worked on various kinds of Transformations like Import Column, Export Column, SCD and Lookup in SSIS as per the client's Requirement.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Involved in writing Stored Procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints, and protection levels.
• Installed and Configured MS SQL Server successfully.
• Expertise in Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Involved in gathering requirements in conceptual data modeling phase.
• Involved in designing database using MS Visio.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of reports using Pivot/Un pivot in Confidential -SQL.
• Scheduled Daily and Weekly Jobs and Alerting using SQL Server Agent.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, Indexes, tables, and views and other SQL joins for building various applications.
• Created and managed Clustered Indexes and Non-Clustered Indexes and optimized queries using Execution Plan.
• Developed multiple dashboards with Power BIdepicting differing KPIs for business analyses.
• Build Bar Charts, Bubble Charts, and Power Map to answer business needs with Power BI.
• Created and maintained logins, Roles and Permissions on the SQL instances and databases and provided required privileges according to the user's requirements.
• Implemented High Availability Concepts, Data base Mirroring, Replication, and log shipping.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in development, enhancement, testing and performance tuning of the application.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Resolved various performance issues by running DBCC command.
• Utilized SSRS Reporting Services to generate several types of reports from the database.
• Created Report Subscription using SSRS.
• Experience with all the modules ofMicroStrategyProduct Suite, namelyMicroStrategyIntelligence.
• I worked extensively inMicroStrategyReporting - Templates, Filters, Metrics, consolidations, Prompts, custom group, and Data mart Reports.
• Generated reports by developing various Schema objects and Application objects inMicroStrategy platform.

Environment: MS SQL Server 2008/2012/2014 (Query Analyzer, SQL Profiler), SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), Power BI, Power View, Business Intelligent Studio, SQL Server Management Studio, Confidential -SQL, MySQL, OLTP, Oracle 11g, Enterprise Manager, MS Excel, Windows XP Professional, TFS, MicroStrategy10.x/9.x.

Confidential

MS SQL/BI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures, and triggers.
• Monitoring SQL Server performance using SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Expertise level of knowledge as a data analyst in data conversion and data cleansing from the raw data sources.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Intensive testing on improving the performance of databases. Hands on experience in controlling Jasper repositories and handed data processing.
• Involved in gathering reports requirements and then generated reports on Jasper.
• Initially used Jasper ETL pro for doing the same, later moved to Talend Integration Suite (TIS) for developing the ETL jobs.
• I have a huge experience in working with complex stored procedures, joins, taking advantage of set based approach to replace time taking cursors, indexes and many more.
• Responsible for making an analysis of transactions of the client and determining solution for settlement of the client account.
• Having hands on experience in DR Processes including Log shipping and Database Mirroring.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, MS Visio, Erwin, LDAP, BCP, Confidential -SQL.

Confidential

SQL Server Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Writing complex queries and generating reports.
• Extracting queries from multiple databases like Teradata, MS SQL, and Oracle.
• Optimized the performance of various SQL scripts, stored procedures, and triggers by using embedded UDFs, CTEs and System stored procedures.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Experience with MS Office software (Excel, Access, and Word).
• Extensively worked on Performance Tuning of Teradata SQL using explain plan and understanding Joins and Data distribution.
• Build, test, and execute one-off procedures as needed to support business commitments.
• Answer business user questions. Investigate and resolve issues or problems that arise. On call for production troubles.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and deployed them on report server.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: MS SQL Server 2005/2008R2, MS Access, MS Excel, SSIS, Crystal Reports, Confidential -SQL, MS Visio, Oracle 10g.