SUMMARY:

• Around 8 years of IT experience, extensively worked in Microsoft Business Intelligence technologies like MS SQL Server 2012, 2014, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Highly experienced in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Experience in dealing with high volume transactional data in SQL
• A thorough Software Engineer with hands - on experience in Database development/maintenance and also well self-trained in cloud environment.

SKILL HIGHLIGHTS:

Languages: Python, TSQL

Tools: Amazon AWS, Jira, ThougtSpot, Automic

Database Technologies: SQL Server 2008/2012/2014/2016 , Oracle 10g/11g, HiveQL

BI: MSBI - SSIS/SSRS, Tableau

Framework: Agile, Scrum

Version Control: Git, Tortoise SVN

PROFESSIONAL EXPERIENCE:

Database Developer

Confidential

Responsibilities:

• Built SQL queries in Hive to populate the daily/weekly/monthly tables using the base tables from multiple resources- SQL Server,Teradata, Oracle.
• Used Apache Spark and wrote scripts in Scala to build ETL packages for generating Inventory,In-stock,Sales reports for various time frames calculating hundreds of complex metrics.
• Built Hive QL queries to validate all the metrics in the reports that are being populated from the daily data.
• Monitoring and validating the daily data load jobs.
• Populating data in BI analytics tool - ThoughtSpot using HiveQL and building pin-boards for all the metrics used in the reports.
• Generating ad hoc reports per business needs.
• Unit Testing, Sanity check, manual and QA data validation for the Merchant business module .
• Scheduling and monitoring daily, weekly, monthly seasonal report jobs in Automic.

MSBI/SQL Developer

Confidential

Responsibilities:

• Generating Sub-Reports, Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services SSRS
• Working on data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Migrating all the reports to the new environment from SAS and Teradata and make it compatible.
• Designing and implementing Stored Procedures and Triggers for automating tasks.
• Build reports with large amounts of data for the business using SQL
• Process data and complex logic in SQL queries, SQL stored procedures and create solutions by analyzing, designing, developing, implementing, testing and maintaining multiple applications.
• Code Programs as per the technical specifications and unit testing, accurately and on schedule.
• Provide assistance in Performance Tuning of any SQL queries.

Environment: - MS SQL Server, TSQL, SSIS, SSRS, Teradata, Snowflake, SAS, Windows Task Scheduler, Python, GitHub etc.

MSBI/SQL Developer

Confidential

Responsibilities:

• Building SSRS reports for the finance teams and SSIS packages based on the business requests.
• Worked in a team building the new Data warehouse system for the company from the design/planning phase till the end.
• Supported the project at the phases of development along with the Data warehouse Architect.
• Built and maintained 2 databases- one for holding just the current data and the other for holding the complete log as part of the data warehouse.
• Data Load from Flat Files, CSV files to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Built a secure paperless method for the technicians to serve the patients by generating Excel Secure Patient List reports by using SSIS packages on their tablets.
• Scheduled Jobs to run once a week to send the report attachment to all the Technicians and General Managers based on their District/Area.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Data cleanup for the historic data in the data warehouse using efficient SQL queries in SSMS 2012.
• Implemented back fill by inserting the data from the past to the current data. Implemented logic in inserting the new rows into the table by following a Load Flags.
• Scheduled report and exported in PDF format and Excel Format as desired by users.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2012.
• Configured the report viewing security for various users at various levels using Report Manager

Database Engineer

Confidential

Responsibilities:

• Created SSIS package to load data from Flat Files, CSV files, and SQL Server 2008R2 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Scheduled report and exported in PDF format and Excel Format as desired by users.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2012.

Business Process Engineer

Confidential

Responsibilities:

• Implemented the SAP Cloud solution to enhance the clients’ business functionality and overall performance, while maintaining a high degree of customer satisfaction.
• Member of the Startup Focus team involved in project team planning and assembling new SAP Rapid deployment solutions in the innovative area of Cloud-based software packages.

SQL Developer

Confidential

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).
• Developed User Defined Functions and created Views. Created Triggers to maintain the Referential Integrity.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.