SUMMARY:

• Over 5 years of IT experience in Information Technology with regards to development and implementation.
• Experienced in interacting with stakeholders/customers, gathering requirements through conversations, and workshops.
• Good at collaboration and interpersonal skills and can work as individual as well as a team player.
• Gathering and analyzing business requirements, work with technology team to recommend and implement best approaches to deliver business solutions.
• Defining business processes, identifying and analyzing risks using appropriate templates and analysis tools along with operating procedures.
• Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T - SQL.
• In-depth knowledge of Database Management (RDBMS) concepts and expert knowledge of designing relational Databases according to business requirements.
• Worked on the design of star and snowflake schemas.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-SQL, MS-Access, Excel.
• Expertise in Performance tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations, Optimization, Data integrity and Statistics by using SQL Profiler.
• Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.
• Worked on SSRS and Tableau reports and Expertise in What-If Analysis using Excel, Power Pivot Reports and Drill Through Dashboards using Warehouses and OLTP Connections.
• Extensive experience in designing and developing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries and Dynamic SQL queries etc.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, SQL Joins, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Involved to developing the .Net scripting in SSIS.

TECHNICAL SKILLS:

Primary Skills: MSBI 2008 (SSIS and SSAS), SQL Server Reporting Service (SSRS) and Excel Power pivot, Power BI, Tableau.

Languages: SQL, T-SQL and PLSQL.

Programming: C, C# and ASP.NET.

Databases: SQL Server 2005/ 2008/2012/2014 /2016.

PROFESSIONAL EXPERIENCE:

Confidential, Fort Lauderdale, FL

ETL/SSIS/SSRS Developer

Responsibilities:

• Installed, configured, managed and monitored SQL Server 2008/ 2012 in development and QA environments.
• Worked in Agile methodology.
• Attended daily scrum meetings and updated the status on User Stories.
• Provided story point estimation for user stories and hours for tasks
• Maintained code in TFS through Git-Hub repository
• Used task trackers like Jira.
• Addressed code review comments in TFS.
• Developed Automation using SSIS Packages to extract data from various sources like SQL Server 2008/2012, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environment.
• Extracted Data by Power Query from external sources and modified the data based on the required format in excel and created SSIS packages to load excel sheet from PC to database.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• The packages created includes a variety of transformations like Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs using SQL 2012 Business Intelligence Development Studio.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representations.
• Created reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports using SQL Server Reporting Services (SSRS).
• Deployed the reports and SSIS packages in Dev and QA environment as well as created the deployment document for deploying the reports and the SQL code in staging and production environment.
• Created various technical documentation, Business requirement gathering, and analyzed data, developed and built SSIS Packages and SSRS reports.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Designed STAR Schema and Snowflake schemas in the project.
• In-depth understanding of Data warehousing concepts such as Kimball’s methodology, OLAP, SCDs (type1, type2 and type3), star schema and snowflake schema.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.

Technologies: Sql 2008/2012, 2016,SSRS and SSIS.

Confidential, Alpharetta, GA

SSIS/SSAS/SSRS/SQL Developer

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
• Created dashboards using tableau and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created actions, filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Maintained code in TFS through Git-Hub repository and Addressed code review comments in TFS.
• Worked in both Waterfall and Agile Methodology.
• Attended daily scrum meetings and updated the status on User Stories.
• Provided story point estimation for user stories and hours for tasks.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration of DTS packages to SSIS packages
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created XML, PDF, EXCEL files using SSRS.
• Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS.
• Used dynamic connection managers using SSIS expressions to load data from different databases into a single DB.
• Developed data reconciliation SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business.
• Create Charts and drill-down chart/reports, Cross-tab report and Sub-Report.
• Schedule and manage daily / weekly / monthly sales and operational reports based on the business requirements.
• Investigate and optimize reporting system performance by optimizing queries, and using report cache and snapshot.
• Write, maintain and update technical documentation.
• Investigate and troubleshoot problems.

Technologies: Sql 2008/2012/2014, Power pivot, Crystal Reports, SSIS and SSRS.

Confidential, Detroit, MI

SSIS/SSAS/SSRS/SQL Developer

Responsibilities:

• Manage and maintain stored procedures and standard reports.
• Developed SQL queries, stored procedures, and functions.
• Design, develop, write, test, and implement SSRS reports and dashboard with multi-parameter, chart, drill-down, drill-through, sub-report and interactive sorting capability for admin, accounting, and sales department.
• Created Cross Tab, Master Detail and Chart reports using Business Objects functionality’s like Combined Queries, Slice and Dice, Formulas, Drill-down analysis.
• Used majority of the transformations, tasks, containers present in SSIS which include Fuzzy grouping, Derived Column, Conditional Split, Aggregate, Lookup, Row Count, Merge Join, Union All, Multicast, Sort, Copy column, Data conversion and other transformations during development.
• Created SSIS Packages to import and export data from Excel, XML and Text files.
• Define Crystal Reports layout and conduct formatting, organize data in Crystal Reports by grouping and sorting, Use Formula and Parameters to develop report.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Performed Database Refresh tasks from production to Development and Staging Servers
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Create Charts and drill-down chart/reports, Cross-tab report and Sub-Report.
• Schedule and manage daily / weekly / monthly sales and operational reports based on the business requirements.
• Investigate and optimize reporting system performance by optimizing queries, and using report cache and snapshot.
• Write, maintain and update technical documentation.

Technologies: Sql, Powerpivot, Crystal Reports, SSIS and SSRS.

Confidential

SQL Developer

Responsibilities:

• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting. Tested and analyzed relational and OLAP data. Enforced different business constrains and rules using triggers and check constraint.
• Performed GAP Analysis on data mappings, and data element transformations.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Developed, deployed, and monitored SSIS Packages.
• Involved in Creation of database, tables, stored procedures, triggers, and user defined functions for dealing with student data.
• Interacting with Onsite people, Taking clarifications regarding applications.
• Involved in writing SQL queries.
• Analyzing the requirements and discussed with managers and leads on the functionality.
• Developed back-end routines using SQL, PL-SQL, and Stored procedures, Packages to check data integrity.

Technologies: Sql, PL/SQL, Crystal Reports, SSIS and SSRS.