SUMMARY:

• Experienced in working as MS SQL Server 2012 (T - SQL, SSRS, and SSIS) / 2008R 2//2008/2005/2000 developer in various industrial domains.
• Experienced in Transact SQL (DDL and DML) . Expert in creating tables, Indexes, joins, triggers, views, stored procedures, filtering user defined data types and functions.
• As part of the team, extensively involved through the software development life cycle (SDLC) involving business process analysis, requirement gathering and development.
• In depth in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package migration wizard and storage management.
• Highly experienced in creating and executing SSIS packages to extract transform and load data. Worked extensively on various data sources and different transformations in SSIS.
• Experience in error handling and event handling: Precedence constraints, break points, check points and logging towards SSIS package execution in SSIS 2012/208R 2/2008/2005.
• Great experience in Deploying SSIS packages, job scheduling, SQL mail agent.
• Created various reports like grouped reports, multilevel grouping, drilldown, multi-level drill down, cascading, parameterized and sub reports.
• Expert in using all types of report formats such as tables, matrix, pie, charts, gauge, maps, and indicators.
• Extensive knowledge and experience in deploying reports and scheduling snapshots and managing snapshot history.
• Experienced in building OLAP cubes, fact and dimension tables with different architecture and data sources for business intelligence and populating/maintaining data marts in SSAS 2012/2008R 2/2008/2005.
• Experience in MS Access creating tables, grids, forms. Created front end forms. Connected Access to different sources and generated reports
• Used multi-dimensional expressions (MDX) queries for calculated members of OLAP cube, key performance indicators, aggregation, and measures in SSAS 2012/2008R2/2008.
• Strong knowledge on data ware house concepts and technologies, worked extensively on developing SSAS cubes, hierarchies, star and snow flake schema of data marts, cubes, data mining models, deploying and processing SSAS objects, ETL process, reporting tools.
• Good understanding of Relational Database Management Systems (RDBMS)
• Expertise in designing and modeling of QlikView Applications using QlikView (11.2/11.0/10.0/9.0 ) with multiple data sources (SQL, Oracle, Flat Files, Excel and Access) relational designs
• Experience with QlikView sheet objects including Pivot, List and Multi box, multiple chart types, Trends, KPI's, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting.
• Strong knowledge of QlikView scripting, Set analysis, aggregation functions, multi-dimensional objects, layout and design including chart properties and formats.
• Strong understanding in creating Dashboards and scoreboards for the required KPI's in QlikView.
• Experience in designing QlikView Document/User Setting Layouts to make consistent and professional optimized look to clients.
• Great skills in gathering requirements, understanding and analyzing the requirements.
• Worked in collaborative team environment with other developers, business analysts and with project management teams.
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.

PROFESSIONAL EXPERIENCE:

MS SQL Server/ Azure Developer

Confidential, Alpharetta, GA

Responsibilities:

• Worked with different team's client, analytics, data sources, QA and visualization. Worked in agile process having expertise in life cycle of a project from start to end.
• Created data warehouse and data marts from scratch based on data structures and reporting needs.
• Worked on writing ad hoc SQL scripts which are required for reporting purposes. Worked on creating basic dashboards in tableau connected to Azure SQL database for client reporting.
• Worked on user management for power bi. Sharing the dashboard access for power bi online.
• Worked on Power BI dash boards and ad hoc DAX queries for power bi. Extensive back end support for many various reports on Tableau and Power BI.
• Created store procedures, functions, triggers, indexes, views based on data processing and data cleansing.
• Created various SSIS packages for data movements and transformations. Worked on Python code to load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query.
• Worked on creating POC for data movement in NiFi (Hortonworks). C# programming used in script task for SSIS and in Azure functions to create retrievers for data pull from API.
• Hands on experience in working with Applications Migration and App Development in AZURE
• Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.
• Worked on Web Applications in Azure and Azure functions to pull data from API to blob Storage and SQL.
• Worked on deploying web sites in Azure and used MVC framework on backend. Experienced in Developing PL/SQL - Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.
• Extensive knowledge in developing PL/SQL codes using Oracle 11g. Worked on creating multiple databases from scratch.
• Worked on Azure SQL data warehouse and database development. Experienced user of PL/SQL for development of server-end program units as well as reusable codes using Procedures and functions. Worked on ad hoc change tickets.

Environment: SQL Server 2012, 2016, SQL Server Data tools (SSIS), AZURE, Google Big Query, Power BI, Tableau.

MS SQL SERVER/SSIS/SSRS DEVELOPER

Confidential, Duluth, GA

Responsibilities:

• Worked on table recovery scripts for each table present in the loan module. Worked on the database recovery scripts for restoring the full back up and transactional logs.
• Worked on creating table structures for entire loan information with indexes and triggers necessary.
• Developed SSIS packages to load data from the flat files pipe delimited to the staging tables and the normalized tables.
• Created Stored Procedures to load data into the actual tables and errored out records into the error tables with error messages.
• Developed the business logic according to the end client requirements and created fixed width flat files from the SSIS packages.
• Worked on creating parameterized report summaries (.pdf) for each loan information, which are called directly from SSIS package with SSIS helpers.
• Worked on data integration with SSIS platform to migrate data. Worked on Zip the folders, creating files folders, deleting, moving files from one folder to another with script task using C#.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Experienced in providing technical and non-technical Production Support. Involved in preparing SQL and PL/SQL coding convention and standards.
• Designed the Fax certification process. Created table structures for the process. Generated parameterized reports with static and dynamic pages based on the loan information.
• Worked on creating reports in excel by dumping data into excel with SSIS packages. Generating data in excel dynamically. Copying the empty excel file on the existing file to populate new set of data.
• Involved in writing C# batch process, to call the reports and send out faxes to respective schools.
• Integrated with front end developers, writing queries for the dashboards in the front end to display data, calculated amounts according to business logic between ranges of dates.
• Worked on complex stored procedures to grab all the files in the required folder, match the part of a file name names with the matching codes in the existing matching tables and dumping the data in the required table.
• In this project, worked with Liquibase database management tool, worked with svn and with the change sets.
• Involved in minimum production support for making changes in the procedures and packages for other projects based on the requirements.
• Involved in the testing the developed codes, package and the output fixed width flat files.

Environment: SQL Server 2012, 2014 Data tools (SSIS, SSRS), Liquibase.

Server/SSIS/SSRS developer/BI Lead

Confidential, Marietta, GA

Responsibilities:

• Worked with financial analyst, application developers, business stakeholders to gather requirements, analyze and build solutions with my team.
• Validated and analyzed the data loaded from flat files for decision making purposes. Worked on presenting data in charts and tables. Worked on designing the data input.
• Worked on SQL server profiler for improving the performance of present quires, created triggers, created and worked on existing Stored Procedures and Indexes.
• Created various ETL (SSIS) packages to load data from CSV files to the tables in SQL Server with using derived columns to specify the file path.
• Loaded the data from source tables to the Netezza server. Worked on the tables and queries in Netezza.
• Checked the health of the SQL Server.
• Created data mapping documents for ETL process (SSIS) . Worked on writing the insert, update and delete quires joining multiple tables to make changes in the staging tables.
• Migrate and upgrade various Oracle versions and patches. Created a front-end application for the finance and sales team with implementing the complex business logic of projected and actual amounts with coding in VB script using MS Access application
• Designed and created various forms for finance team, sales team and account managers with implementing the business logic. Worked with non-technical teams to help them to use the application.
• Designed the structure of history tables for the finance team. Worked on creating various reports in SSRS (matrix, multi drilldown, parameterized) and scheduled the snapshots.

Environment: SQL Server 2012, SQL Server Data tools (SSIS, SSRS), MS Access 2013, Excel.

SSRS developer

Confidential, Marietta, GA

Responsibilities:

• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Determined the SQL Server installation. Installed and configured SQL Server Management tools using SQL Server setup program.
• Implemented triggers for checking complex business conditions, providing security for tables.
• Physical implementation of database into SQL Server 2012 using T-SQL.
• Created views to facilitate easy and user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Created stored procedures and functions to support efficient data storage and manipulation. Created check constraints to maintain data integrity.
• Created various SSIS packages by extracting data from various sources according to the requirements.
• Load XML data in SQL Server table using SQL bulk copy. Worked with various containers in the control flow task such as For Loop, For EachLoop, and Sequence.
• Worked with various sources in the data flow tasks and used various transformations. Some of the transformation are Row count, merge, merge join, union, Look up transformation, audit, aggregate.
• Worked extensively on bad data with configuring the error output, Conditional split, derived column, fuzzy lookup transformation.
• Deployed the packages in catalog method and worked on job scheduling and send mail task.
• Created tabular, drill down and parameterized reports using SSRS. Migrated ad-hoc reports from excel and crystal reports to SSRS.
• Gathered and documented QlikView application requirement from the users. Designed, developed and implemented QlikView Business Intelligence reports
• Strong understanding in creating Dashboards, scoreboards for the required KPI's in QlikView.
• Implemented security using QlikView section access that dynamically hides selected areas of the dashboards depending upon the user privileges.

Environment: SQL Server 2012, Excel, Access and Windows NT, MS SQL Integration Services (SSIS) and MS SQL Reporting Services (SSRS). QlikView 11.2/11.0

MS SQL Server/ SSRS Developer

Confidential, Alpharetta, GA

Responsibilities:

• Designed, Developed and maintained Relational databases using agile scrum methodology, SME phase.
• Involved in normalization of the database and bringing it to 3NF. Created efficient stored procedures, triggers, user defined functions, tables, views, and other T-SQL join techniques for applications and improvement of database performance.
• Extensively involved with database space management, performance and writing SQL queries with Teradata.
• Generating XML from SQL server tables. Created various reports in SSRS according to the requirements. Some of the reports are grouping, multi-level grouping. drill down, multi-level drill down, Parameterized, cascading parameterized and sub reports
• Used various representations for the reports some of the representations are table, charts, pie, maps, gauge, matrix and indicators.
• Involved in configuring the report server. Deployed various reports to the report server and managed user permissions. Created different levels of security such as server level security, folder level security and report level security.
• Generated daily, weekly and monthly reports as per the customer requirements using subscriptions and maintained the snapshot history. Created ad-hoc reports using report builder.

Environment: MS SQL Server 2012/2008, SSRS, MS SQL Profiler, MS Access, MS Excel

MS SQL Server SSIS/SSRS/SSAS Developer

Confidential, Georgia, GA

MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed new ETL packages using SSIS to validate extract, transform, and load data to data warehouse and data mart databases from excel spread sheets, flat files and OLEDB sources.
• Writing triggers, functions, views, and indexes and developing T-SQL code as stored procedures and functions to be used directly in generating reports.
• Created different types of ad-hoc, cross-tab, sub-reports, tabular, parameterized, drill down and multi drill down reports.
• Deployed reports to the reports server and managed different levels of security. Managed subscriptions and snapshot history.
• Used MDX queries for the calculated measures and KPI's to design star schema using dimension tables and fact tables in SSAS.
• Created SSIS packages using slowly changing dimension, pivot transformation, derived columns, term extraction, execute SQL task and execute package task etc. to generate underlying data for the reports and to export cleaned data from XML files, excel spread sheets, text file, and CSV files to data warehouse / OltpDB.
• Scheduled jobs for executing the stored SSIS packages, which were developed to update the database on daily basis using SQL server agent.
• Deploy SSAS OLAP cubes on development and production server for performance analysis.
• Created user defined data types and to model database to be deployed into production environment.
• Designed and developed BI Reporting solution, enabling users to effectively utilize the tool and create.
• Analytical Reports, Dashboards, and Scorecards, align KPIs performance metrics to strategic drivers and priorities. Testing dashboards and data validation.

Environment: SQL Server 2008/ 2008R2, 2012 T-SQL, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), T-SQL, QlikView 9.0

MS SQL Developer/SSIS/SSRS Developer

Confidential, Alpharetta, GA

Responsibilities:

• Migration of data from different sources (text based files, excel spread sheets) to MSSQL.
• Implemented triggers, functions, stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up efficiency of queries and analysis in SQL server management studio.
• Used MS SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Worked on querying the data and creating on demand reports using report builder in SSRS reports and send the reports via email.
• Developed stored procedures and views to generate various drill down reports, parameterized reports using SSRS.
• Designed and created bar graphs, pie charts, power pivot tables and deployed them on to the web server for viewing. Capturing XML data from the server.
• Built efficient SSIS packages for processing fact and dimension tables. Defined the logging process for all the packages and populated it with entries like inserted record, update record and error record.
• Involved in managing developers, advising other groups in organization on SSIS development, data warehouse development and ETL development.
• Created an ETL automated summary report which consists of the summary information for all the loading activities done each day and month.

Environment: MS SQL Server 2005/2008, Business Intelligence MS SQL Server Integration Services (SSIS), MS SQL Reporting Services (SSRS), MS SQL Analysis Services (SSAS), Teradata.

TECHNICAL SKILLS

Microsoft AZURE, Google Big Query, MS SQL Server 2012/2008R2/2008/2005/2000, T-SQL, MY SQL, MSSQL Server Reporting Services (SSRS), DTS, XML, MSSQL Server Integration Services (SSIS), SQL Profiler, SQL Query/Index Analyzer, MSSQL Server Analysis Services (SSAS), Backup/Restore Server, OLAP Services, SQL Alerts, SQL jobs, ERwin, Qlikview, Power BI