SUMMARY:

• Around 6years of experience in IT as a SQL Developer with specialized skills in SSIS, SSAS, and SSRS.
• Experience in managing security of SQL Server 2016/ 2014/2012/2008 R2/2008/2005 databases by creating database users and roles and assigning proper permissions according to business requirements.
• Strong SQL Server 2014/2012/2008 R2/2008 development skills including writing stored procedures, user - defined functions, triggers, views, and indexes.
• Proficient with SQL Server, BI Stack (SSIS, SSAS, and SSRS), Power BI, and Tableau within large and complex environments.
• Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Server Reporting Services (SSRS)/ Power BI.
• Experience in developing end-to-end Business Intelligence solutions in accordance with Standard OLAP Methodologies using Tableau.
• Experience in Data Modelling and CASE tools like ER/Studio.
• Created and maintained numerous Crystal Reports including financial and operational Reports.
• Used TFS 2010 to check in SQL scripts, reports and Integration packages. Involved in documenting the entire technical process.
• Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Validation of the scripts and to check in the scripts like tables, views and stored procedures in to TFS.
• Strong Transact-SQL query writing skills (DDL, DML, and DCL).
• Excellent command writing ad hoc queries utilizing dynamic SQL.
• Extensive experience on Business analysis and Enterprise reporting solutions delivery using Crystal Reports.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS process design architecting the flow of data from various sources to target.
• Expert in SQL Server Business Intelligence suite of products like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
• Expertise in creating reports of all types in SSRS, like ad hoc, drill-down, pivot, and tabular reports.
• Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications.
• Expert in creating complex Crystal Reports (Ad-hoc Reports, Frequency Reports, Summary Reports, Drill Down, Dynamic Grouping, Graphical, aging Reports).
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Develop optimized SQL Server stored procedures, functions, and database views
• Experience using SSIS tools like Import/Export Wizard, Package Installation, and SSIS Package Designer.
• Strong experience in defining referenced relationships and identifying KPIs in SSAS 2008/2005.

TECHNICAL SKILLS:

Operating systems: Windows XP/Vista/7/2008R2

Databases: SQL Server 2005/2008/2008 R 2/2012/2014/2016 , Access

Database tools: SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, Microsoft OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), EDI

ETL tools: DTS, SQL Server Integration Services, SQL Server Analysis Services, EDI Kit

Reporting tools: SQL Server Reporting Services (SSRS), Crystal Reports

Development skills: Transact SQL (T-SQL), PL/SQL

Application packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, Springfield, OH

SQL BI /Power BI developer

Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Developed reports and visualizations using Tableau Desktop as per the requirements.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• Created Crystal Reports Repository objects (Reports template, commands)
• Involved in the data analysis and database modeling of both OLTP and OLAP environment.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Developed custom reports using SSRS/Power BI.
• Designed, Managed and published various reports using SQL Server Reporting Services 2012 and Power BI.
• Designed Dimensional Modeling using SSAS cubes for End-User.
• Collaborated in dramatically increasing OLTP transactions on systems handling several billion transactions weekly through the implementation of advanced database techniques such as join optimization, table structure and fragmentation analysis, bulk inserts, analysis of indexes and locks, creation of custom timers to detect bottlenecks.
• Thorough analysis and testing of database objects &T-SQL statements before deployment to the production server.
• Migrated and translate legacy reports into Power BI from SSRS environment.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Used DAX query in writing queries and de ning measures and calculated columns in PowerPivot and in tabular models in SSAS.
• Developed number of business-oriented reports utilizing SSRS, Power BI and Tableau.
• Administered and maintained the BI Portal, Data warehouse and existing BI solutions.
• Responsible for creating the Complex Crystal Reports (on demand, AdHoc reports, Frequency reports, Summary reports, Sub reports, Drill-Down, Crosstab, Dynamic Grouping, Csross-Tab, Graphical, Aging reports) and modifying the existing reports.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Use Analysis service processing task to process the analysis cube in SSAS after DW run
• Developed Tableau data visualizations using Cross Map, Scatter Plots, Geographic Map, Pie Charts, and Bar Charts.
• Worked on forward and reverse engineering data architecture using data modelling tools like ER/Studio
• Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI.
• Strong Knowledge of Software Development lifecycle and methodologies like Waterfall, agile methodology and Scrum approach.
• Using TFS for proper documenting and implementing of codes on all environments.
• Created highly complex SSIS packages using various Data transformations like Conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2014 and unit test SSIS load processes for performance check.
• Implemented advanced features in SSAS including translation, role based security, custom actions, SSRS actions & partitions
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Implemented Drill Through actions in SSAS to provide quick access to granular
• Created multiple data visualization solution for initial Power BI environment business preview.
• Involved in migration and Conversion of Reports from SSRS .
• Created Tabular reports, Matrix reports, List & 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.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.

Environment: SQL Server 2016/2014/2012 Enterprise Edition, .Net 3.5, SQL BI Suite (SSAS, SSIS, SSRS), OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access & Windows Server 2008R2, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, ER/Studio, Tableau 9.1(tableau desktop, tableau server, tableau online).

Confidential, Dallas, TX

SQL BI Developer/ Power BI developer

Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• 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.
• Used Window azure to deploy the application on cloud and managing the session. Worked on Azure Data Factory for Extract& Load data.
• Experience in extracting data from Azure HDInsight and publish the transformed data into AzureSQL Data Warehouse and build reports on BI platform.
• Developed SSAS solution for analytical reporting; implemented best practices for optimal performance
• Worked with different types of variables (Local, Global, and Shared) in writing formulas.

  Scheduling the reports depending on the users request to receive in different formats (Email, Public folder etc) in Crystal Enterprise using Crystal Reports Scheduler.

• Created and configured an OLTP replication database for disaster recovery purpose.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Good understanding of Software Development Life Cycle(SDLC), Agile Methodologies.
• Created Hierarchies, Aggregations, partitions, calculated members and dashboards and scorecards with KPIs inusing SSAS.
• Scheduling Jobs and Alerting using SQL Server Agent in Power BI
• Created SSIS package to extract, validate and load data into Data warehouse.
• Expert in creating Star schema cubes using SSAS.
• Extensively worked on creating and managing OLAP cubes using SSAS
• Extensively worked on creating SSIS packages and have used for each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Created the SSIS packages and scheduled them using SQL Server agent.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed Dimensional Modeling using SSAS packages for End-User
• Created Crystal Reports Repository objects (Reports template, commands)
• Utilized Event Handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Creating SSIS Packages to extract data from CSV and TXT files into schema tables and sends Email attachment of the extracted data.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development.
• Extracted data from XML to SQL server.

Environment: SQL Server 2008R2 Enterprise Edition, .Net 3.5, SQL Server Data tools (SSAS, SSIS, SSRS), Enterprise manager, PPS, Azure SQL XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2008, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007

Confidential, Columbus, OH

SQL BI Developer

Responsibilities:

• Analyzed user requirements and functional design, and prepared technical specifications, unit test plans, and created platform to run and validate the test cases.
• Worked with Subject Matter Experts (SMEs) in understanding, documenting, developing, and testing their requirements.
• Responsible for understanding the technology, and the requirements, and delegate work to the team in India.
• Migrated DTS packages from Legacy system like PARAGON to SQL SERVER 2005.
• Responsible for Knowledge transfer and training existing and newly recruited resources on various Loan IQ View practices and processes such as report development, deployment, coding and tools used for managing and developing reports, deploying or executing components, and batch application.
• Generated matrix reports, tabular reports, drill down, drill through, sub reports and multi-parameterized reports.
• Performed modifications to DB2SQL code used to deliver data to downstream application interfaces.
• Demonstrated solid Reporting and SQL skills to coordinate changes to existing reports and develop new intraday and batch reports needed.
• Ran the Autosys batch jobs every week to generate reports in the LIQV(Web Application) after the scheduled LIQ batch runs for respective environments in SIT and UAT.
• Created different Parameterized Reports (SSRS 2008 R2) consisting of Report Criteria in various reports to minimize the report execution time and to limit the no of records required.
• Deployed Global and Zonal reports to Report server weekly, monthly and quarterly using Anthill and well as manually using Report Manager.
• Worked with financial systems team members to document systems and process environments.
• Submitted the ESRs to track the SIT, UAT and Production deployments and was also the Eastern Standard Time communication vehicle and deployment point person for work completed overnight in India.
• Attended to high priority report development and defect fixes for emergency and off-cycle releases and met deadlines in a rapid release cycle.
• Presented excellent communication skills and coordination skills to effectively work with other team members and get the development completed as per the deadline.
• Promoted the company culture by approaching each day with team-oriented and can do attitude.

Environment: SQL Server Management Studio, HP Application Lifecycle Management 11.0, Power BI, Beyond Compare 3, Microsoft Visual Studio 2010, Microsoft Lync 2010, Microsoft SQL Server 2008 R2, SQL Server Business Intelligence Development Studio (BIDS), Tortoise SVN 1.7.6, Anthill, AutoSys, JIRA, SSRS 2008 R2, SharePoint 2010, MS Office 2010.

Confidential

SQL Server Developer

Responsibilities:

• Studied and understood requirements of information required by company’s procurement department about vendors.
• Normalized data sets and re-designed data from scratch, including logical and physical design.
• Actively involved in troubleshooting problems throughout development process.
• Installed, updated, configured, and maintained SQL Server.
• Created report interface using VB6, which allowed users to select and dynamically filter reports.
• Tuned front-end applications like Visual Basic, which queried SQL Server database.
• Involved in implementation of user logins, roles, and profiles as part of security policies for various categories of users.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user-defined functions.
• Wrote T-SQL queries for data retrieval.
• Developed administrative tasks of SQL Server for performing daily backups and recovery procedures.
• Worked with development team in writing functions in VB6 for upload/download functionality, data transfer, and migration.
• Involved in developing functions in VB for encryption and decryption of passwords and user names.
• Developed code and analyzed it in VB6 for front-end interface.
• Played important role in ensuring timely delivery of whole set of data and queries to procurement department.

Environment: SQL Server 2008/2005, Windows NT, Visual Basic 6.0, Access, Excel, Windows 2003.

Confidential

MSBI Developer

Responsibilities:

• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005/2008 and Flat files
• Responsible for Creating and Modifying T-SQL stored procedures for validating the Integrity of the data.
• Created indexed views, and appropriate indexes to reduce the running time for complex queries.
• Involved in installation and configuration of SQL Server 2005, SQL Server 2008 and SQL Server 2012 with latest Service Packs.
• Participated in designing a data warehouse to store all information from OLTP to Staging and Staging to Enterprise Data warehouse to do better analysis.
• Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data.
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS)
• Captivated proper error handing techniques like logging, checkpoints, and event handler to handle errors in the package.
• Designed and developed several enterprise reports using the data from ETL Loads and heterogeneous sources.
• Worked on Reporting subscription services such as data driven subscriptions for email and file sharing.

Environment: MS SQL Server 2008 R2, MS SQL Server Integration Services 2008 R2, MS SQL Server Reporting services2008 R2, Visual Studio 2008, Windows XP, MS Office 2007