SUMMARY

• Having 12+ years of experience in SQL Server 2000/2005/2008/2012, SSIS, SSRS, SSAS and Database Modelling & Designing.
• Expertise in Design, Implementation, and Management of Database and Data Warehouse Systems; Data Modelling, Business Intelligence, Data Analytics with experience and training in text mining for predictive analytics.
• Have demonstrated strong troubleshooting, problem solving, leadership and team work skills as well as the ability to accomplish tasks under minimal directions and supervision.
• Perform Data Modelling in OLTP and OLAP systems using ERWIN and Embarcadero Enterprise Architect/Toad modeller with hands on experience in ERDs, DFDs, Data and Process Mapping, Sequence Diagrams, XML, DML, DDL, TCL, DCL and MDX.
• Perform database tuning, SQL optimization, upgrades, backups and recovery with in - depth experience in creating complex queries, stored procedures, views, and triggers using SQL, PL/SQL & T-SQL.
• Experience in implementing entire business rules and doing entire computation in SSIS package using ETL tool SSIS.
• Experience in creating converting/enhancing SSRS reports and visualizing and emphasizing data.
• Experience on working SSAS, creating Cubes, using Cubes to generate Analytical Reports using SSRS.
• Knowledge of BigData architecture, Training on Hadoop & Hbase.
• Have strong customer service, communication, and presentation skills, with experience in translating complex ideas and methodologies into simple terms for non-technical team members, users and stakeholders during gathering, analysing and implementing project requirements.

TECHNICAL SKILLS

Databases: MS SQL Server 2012, SQL Server 2008, SQL Server 2005 and SQL Server 2000, SQL Azure and Oracle 10G:

Database Tools: SSIS 2012, 2008 and 2005, SSRS 2012, 2008 and 2005, SSAS 2012:

Software Skills: C# .Net, Visual Basic 6.0, XML (Understanding Level):

Tools: and Technologies: Enterprise Architect, Microsoft Visio, Microsoft Project Professional, Microsoft Project Servers, Smart Card application, Tidal, LiteSpeed & ApexSQL:

Knowledge of: Pentaho ETL Tool, Sisense BI Tool, Big Data:

PROFESSIONAL EXPERIENCE

Confidential

Lead Database

Responsibilities:

• Design Database and Create Database Model of both Relation and Multi-Dimensional Model for the new modules of the product.
• Design and Create SSIS Package to migrate data from different source system. Create Field Mapping sheet and Audit Report of ETL process.
• Design architecture and Create SSIS package to process policy data for Calculation of Commission, Incentive, Profit Sharing Bonus that usage last three years of data. Size of data is 4TB.
• Design architecture and Agent/Agency Experience and Forecasting report based on last seven years of data i.e. 11TB
• Design and Implement Data Partitioning and automate archiving.
• Create SSRS Reports and Subscriptions of Commission, Incentive and Profit Sharing reports.
• Create ERD (Logical & Physical Model), DFD, Technical Design Document,
• Debug and Improve Performance Issues and guide team members and review their work.
• Work closely Client to understand their business requirement and transform that into technical environment. Also, work closely Technical Team Member to integrate Compensation module changes or requirement in the application UI.
• Deployment, Training and support of specific modules.

Confidential

Manager Database

Responsibilities:

• Working with client as a third party consultant to Review & Assist in implementing Data warehouse of their Manufacturing unit to integrate Accounts, Billing, Human Resource, Technical Devices and other department data.
• Understanding Business Requirement and Creating Architecture and Technical Presentation to Board Member.
• Creating Flowchart to define Technical Approach, ERD (Logical & Physical both) and DFD to explain approach and Lead Technical Team to implement model designed.
• Creating OLTP and OLAP model for Reporting and Transactional Data.
• Creating SSIS Packages and Designing Java code to parse and pull structured and unstructured data into structured data model from Oracle 10g, DB2, FoxPro, .sln, PDF, .txt MS Access, Excel and SQL Database.
• Designing Cube and Generating BI Reports using SSRS. Managing and Maintaining reports in different format i.e. PDF, Excel, .CSV.
• DB Scripts Development (Stored Procedure, Trigger, Functions etc.) and SQL Query Building tool on SQL Server 2008/2012.
• Supported issues with reports and deployment on the enterprise environment (Development, UAT, Test and Production).

Confidential

Lead Database

Responsibilities:

• Created Database Model using Toad Modeller to redesign existing module and deploying that to SQL Azure.
• DB Scripts Development (Stored Procedure, Trigger, Functions etc.) and SQL Query Building tool on SQL Server 2008/2012.
• Creating custom SSIS Package to pull data from different source like CSV, Excel, XML, .SQL & MS Access and analyse data and translate/transform data according the need of Product.
• Creating SSRS reports based on Clients random requirement that is not part of the product.
• Troubleshoot performance issues using SQL Profiler, Execution Plan and Statistics and optimize SQL Stored Procedure, Trigger, Function to improve performance of the application.
• SQL Server Database Administration like automating backup plan using LiteSpeed, Restore, Mirroring and creating replication server.

Confidential

Sr. Consultant

Responsibilities:

• Designing Database Architecture to reengineer existing application to remove data anomalies, improve performance and make that highly available transaction database.
• Create DFD, ERD, Data Dictionary, Field Mapping & Data Auditing report to present that to client.
• Directly interaction with end-user to understand their business need and enhance application architecture based on that.
• Creating Technical/Functional Requirement Document, Technical Design Document, Pseudo code for Development team.
• DB Scripts Development (Stored Procedure, Trigger, Functions etc) in Oracle 10g and SQL Server 2005/2008
• Creating SSIS package (2005 and 2008) to migration data from existing database to new designed database.
• Upgrading Clients existing DTS package to SSIS Packages.
• Creating new SSRS reports and migrating existing D2K Reports to SSRS reports (2005 and 2008).
• Query Optimization and Performance Tuning
• Deployment and Technical Support.

Confidential

Sr. Software Engineer

Responsibilities:

• Leading a Team of three Database Developer
• Involved in Requirement Gathering (Business and Functional) and Analysis. Create Impact Analysis and Technical Design Document.
• Creating Backup Plan, Managing and Executing Database Up-gradation from SQL Server 2000 to SQL Server 2005.
• Creating and Modifying Stored Procedure, Trigger, Functions and SQL Query Building in SQL Server 2005
• Troubleshoot and Optimization SQL Query
• Client Communication and Application support,
• Application Development using Visual Basic (Only Basic Development Work)

Confidential

Software Engineer

Responsibilities:

• Working independently with the client comScore Inc. and involved into the entire development, maintenance process,
• Identifying Processes to be Automated, Designing and Defining Process Model and Automating those Processes,
• Development and Maintenance of Database Objects (Stored Procedure, Trigger, Functions etc.) and SQL Query Building in SQL Server 2005,
• SQL Query Optimization and Performance Tuning in SQL Server 2005
• Client Communication and Support to Development, Testing and Data Analysis Team,
• Application Development using Visual Basic and C# .Net,
• Server and Process monitoring.