SUMMARY

• A result oriented Developer/Analyst having around 6 years of experience in various industries with solid understanding of SDLC, Requirement Gathering, Business Process Flow, Business Intelligence and Data warehousing.
• Conversant with all phase of Software Development Life Cycle (SDLC) using Microsoft and Open Source starting from research and client facing to development.
• Projects worked during professional period includes management information system, content management system, operational systems and business intelligence.
• Strong knowledge about Logical & Physical DB Design, Normalization and Data Modeling.
• Highly experience in using T - SQL for developing complex Stored Procedure, views, User functions, CTE and SQL Joins.
• Expert of using Business Intelligence Development Studio (BIDS) for Tabular, Drill Down, Drill through, KPI, Parameterized, Graphical Chart reports using SSRS.
• Experience of ETL process using SSIS from different source such as MySQL, Postgres, Excel and Flat file to SQL Server using Conditional Split, Derived Column, For-Each Loop, Aggregate, Sort, Data Conversion, Merge and Script Task.
• Designing and Deploying data cube in SSAS.
• Proven analysis, problem solving, and troubleshooting expertise.
• Extensive experience on ODBC connector and Linked Server to get data from remote database server.
• Extensive experience to analyze the requirement to determine the complexity and to identify data gaps.
• I am interested in new emerging technologies and trends of database technology. Currently I have been learning Python and MongoDB. Also, I am planning to learn Hadoop with Hive and Pig.
• I have friendly, affable but focused client facing skills and a strong analytical mind, which I am seeking to use with a stronger business analysis side.

PROFESSIONAL EXPERIENCE

Database & Reporting Developer/Analyst

Confidential

Responsibilities:

• Create, schedule, and deploy reports with Microsoft SQL Server Reporting Services (SSRS).
• Write and maintain TSQL script based on the existing Postgres Database and upsized NHS SDS Non-NHS organisation Access DB design into SQL Server using ODBC connector and Linked Server.
• Work on ETL process using SSIS to get data from Postgres database.
• SQL Optimization and Data Analysis
• Create data quality tabular reports, KPI reports, and parameterized reports.
• Designed numerous ad-hoc and custom reports using SSRS.
• Identify data gaps and research to fill these gaps and make recommendation.
• Take the initiative on solving complex data problems.
• Assist with analysis of data to answer new and unsolved questions.
• Scheduling and deploying the reports on the windows shared environment.
• Maintain documentation and train end users.
• Assist in developing, deploying and testing new HA system.
• User acceptance test plan based on business requirement.
• Providing other IT development assistance as required.

Developer, Subcontractor

Confidential

Responsibilities:

• Write and maintain custom reports for existing Case Management System using SSRS
• Work closely with Front End developer / Business and Operation Manager of client to understand their requirement and system workflow.
• To analyze the application to determine complexity, to identify data gaps against new requirements or conflicts across the application.
• Write and maintain TSQL script on SQL Server based on the existing Postgres Database design using Linked Server.
• SQL Optimisation and Data Analysis
• Generate client side report tabular reports, KPI reports, and parameterized reports using SSRS.
• Work with system engineer to subscribe SSRS reports in excel format on shared drive.
• Involved in Sharepoint SSRS and Excel report migration.
• Documenting the reporting system and infrastructure design.
• Providing other IT development assistance as required.

Developer, Contractor

Confidential

Responsibilities:

• Write and maintain custom reports for existing Case Management System using SSRS
• Write and maintain TSQL script based on the existing Postgres Database and upsized NHS Access DB design into SQL Server using Linked Server.
• Documenting the current reporting system and its infrastructure design.
• Providing other IT development assistance as required

Developer

Confidential

Responsibilities:

• Work independently in all stages of development life cycle including analysis, design, implementation, testing and maintenance.
• To work closely with Managed Services and Professional Services team, and clients to gather requirement specification and used them to create REPORTS/DASHBOARDS for evaluating Key Performance Indicators.
• As an active team player, work closely with Business System Manager to understand existing application Connectwise and Contact Centre for creating its custom reports/dashboard using SSRS, PowerGadgets and PowerPivot 2010.
• Create and maintain stored procedure and views to create the reports for Business Performance Evaluation.
• Work on report automation (Emailing the respective email to appropriate member).
• To create an IT monitoring custom report for Labtech using reporting services.
• Work on ETL process for Data Migration from MySQL Server to MSSQL Server 2008 using SSIS.
• Developed an application named Backmon for Backup Monitoring which takes data from Exchange Mail server through ETL package for Data Visualisation.
• Automation of Carrier Services Department with MSSQL Server 2008 R2/SSRS and .Net 4.0 framework.
• Developed test cases and conducted different level of testing like Unit, functional and scenario Testing.
• To work intimately with System Engineer to understand and deploy the created application in the server.
• Configured IIS 7.5 for Application Deployment in Windows Server 2008 R2.
• Documentation of developed applications which includes Use Case Diagram, Activity Diagram and ERM Diagram.
• Project Management.
• Work closely with Nimsoft Support Engineer to configure its infrastructure manager and to create mock up of IT monitoring dashboard for Confidential Client.
• Work on Customer Portal using .Net framework 4.0 and SQL Server 2008.
• Work on Custom Report for Clear 2 Case Management System (Postgres, SQL Server 2008 and SSRS).