SUMMARY

• Over 12 years of experience IT involvement, including 4 years’ experience in MS SQL Server Database Design, Analysis and Reporting.
• Expertise in array of domains from Health Care, Electronics, Banking and Financial Service Providers.
• Experience in installing, updating and configuring SQL server 2000/2005/2008/2008 R2/2012.
• Hands on experience in Writing & Debugging Stored Procedures and Triggers, Troubleshooting Database issues.
• Experience with Tuning SQL Queries & Stored Procedures to improve performance.
• Hands on experience in database administration work such as setting SQL Server Agent jobs for backups.
• Expert in extracting, transforming and loading (ETL) data, from different Data sources like MS Access, Excel, Flat File and Oracle, to Microsoft SQL Server using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
• Good experience in usage of SSIS Control Flow items(For Loop, execute package/SQL tasks, Script task, send mail task)and SSIS Data Flow items(Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Hands on experience in configuring and maintaining Report Manager, Report Server and Repot Builder for SQL Server Reporting Services (SSRS).
• Hands on Experience about other aspects of reporting service such as Report Authoring, Report Management, Report Delivery and Report Security.
• Hands on experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports likedrill down, Parameterized, Cascading, Conditional,Table, Matrix, Chart, and Sub Reports and formatting.
• Hands - on experience in the scheduling of reports to refresh and run on daily, weekly and monthly basis and also deployment of the reports using Direct deployment and Uploading files using the Report Manger.
• Developed Dashboard Reports using SSRS, Report Model and Ad Hoc Reporting using Report Builder.
• Involved in integration of SSRS Reports using various web parts into SharePoint and Performance Point 2010 and Dashboards.

TECHNICAL SKILLS

DBMS: MS SQL Server 2000/2005/2008/2008 R2/2012, Access 2000/2003

Programming: T-SQL, PL/SQL

Developer Tools: SQL Server Management Studio, SQL Profiler, SQL Query Analyzer, Import/Export, Visual Studio 2005/2008, Oracle PL/SQL

OLAP/ Reporting Tools: SQL Server Analysis Services (SSAS), SQL Server Reporting services (SSRS), Crystal Reports

Data Modeling: MS Visio 2000/2007/2010, Power BI

Operating Systems: Windows NT/ 98/2000/2003, 2008R2 Server

Web Technologies: Basic Knowledge of HTML, XML, JAVA SCRIPT, CSS

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

SQL BI Developer

Responsibilities:

• Assisted in complete Life Cycle including Design, Development and Testing
• Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided
• Deployed the generated reports onto the report server
• Designed and Developed matrix, tabular, parametric and Sub Reports in the SQL Server Reporting Services 2012
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text file and CSV files
• Applied various Data flow and Control flow transformations to meet the business needs
• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the scheduled jobs
• Migrated DTS packages using DTS editor wizard inSSIS,validated and tested all packagesondevelopment server
• Implemented the concepts of Incremental Data Load, Slowly Changing Dimensions for updating and maintaining the history of the records
• Created and Configured Dimensions, Attributes and Hierarchies
• Designed and Developed KPIs, Aggregations and Cube Partitions
• Used Execution Plan, SQL Profiler to optimize queries and enhance the performance of Databases.
• Constructed SSAS Cubes based on data volumes mostly adhering to Star Schema
• Defined check constraints, rules, indexes and views based on business requirements.
• Managed and created and altered Databases, Tables, Views, Indexes, Constraints with business rules using T-SQL
• Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement
• Monitored time taking queries with Performance Tuning to reduce the execution time
• Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
• Created SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Migrated data from text files and Excel spreadsheets toSQLServerdatabases using Integration Services (SSIS) & Power BI tool for pivot SQL data with MS Excel 2010.

Environment: SQL Server R2, SSIS, SSAS, SSRS, Windows Server 2012, VB.Net, C#, VS 2012

Confidential, Park Ridge, IL

SQL SSRS/SSIS Developer

Responsibilities:

• Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2008R2.
• Coordinate with business users in gathering business requirements and translating them to technical specifications.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created usage based aggregations in cube to minimize time for query retrieval.
• Create Different types of reports based on customer Request.
• Create Sub Reports and Drill-Through Reports and developer them to share Point Server.
• Working on performance tuning to Test the Query Execution.
• Created Ad-hoc Reports, Sub Reports, Drill-Through and Drill-Down Reports.
• Data migration using DTS services across different databases like Oracle, MS access 2003 and Flat Files.
• Worked on tabular and dimensional data analysis from data oracle warehouse.
• Pulled history data into excel using visual studio for different heads of insurance claims.
• Wrote simple and detailed PL/SQL procedures for analytical reports.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Exposure in using Team Foundation Server as a source control, source repository and project tracking solution.
• Created Datasets inT-SQL, stored procedures forSSRS.
• Created Reports in SSRSwith different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Created Dashboards in SSRS2008.

Environment: Microsoft SQL Server 2008R2, Visual Studio 2008, Visual Studio 2005, T-SQL, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Team Foundation Server (TFS), Visual Source Safe and Share point 2010 MS Word, Ex-cell.

Confidential, New York

SQL Server Developer

Responsibilities:

• Participated in joint application development session (JAD) to gather information about clients need and to get familiar with vendorsproduct.
• Wrote T-SQLstatements to ensure data consistency by filtering corrupt data and implemented variousconstrainsandtriggersto preserve data integrity.
• Developed effectivestoredprocedures, functionsto implement business logic.
• UsedBulk Inserttocopy large amount of data into database.
• Designing, testing and managing disk\tape Backups and Recovery strategies.
• Backing upmaster & system databases andrestoring.
• Design and automation of disaster recovery procedures.
• DevelopedMerchandise Business Analysis reportfor Top management and Category Buyers using reporting services(SSRS)and deployed to reportserver.
• Migrated data from text files and Excel spreadsheets toSQLServerdatabases using Integration Services (SSIS).
• Maintained and createdReplication:Merge,Transaction and Snapshotand also implemented data transformation to the published articles
• Increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by usingPerformance Monitor,Profiler, andIndex tuning wizard.
• Participated in testing and debugging to validate data after the export/import/delete.

Environment: SQLServer2005, VB 6.0, XML, VB.Net, SSRS, SSIS

Confidential

MIS/ ERP Specialist

Responsibilities:

• Participated in GAP Analyses to gather information about clients need and to get familiar with vendor’sproduct.
• Wrote T-SQLstatements to ensure data consistency by filtering corrupt data and implemented variousconstrainsandtriggersto preserve data integrity.
• DevelopedBusiness Reportfor Top management using reporting services(SSRS)and deployed to reportserver.
• Designing, testing and managing disk\tape Backups and Recovery strategies.
• Helped to designed all kind of production and sales reports for Sales and procurement departments using SSRS.
• Analyzed the business and functional requirements and provided high level technical design specification to drive ETL development efforts.
• Managed QA and PROD deployments and automation of ETL Jobs.
• Provided assistance in diagnosing production problems related to the project.
• SQL Server 2008 - Dealing with complicated Data issues with multiple rows, reporting continuous activity.
• Generated periodic reports based on the statistical analysis of the data using SQL server Reporting service (SSRS).
• Created Drill through reports which give all the details of various prior authorizations for approved and denied member and providers for different states.
• Assisted business users and end users to schedule and write subscription on report manager.
• Created stored procedures and user-defined functions for different Reports.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Produced SSRS 2008 reports for State wide reporting.
• Annual Stock and financial statistics reporting with visual effects, charts, graphs and gages in visual Studio 2008

Environment: MS SQL Server 2008/2012, SSIS 2008 R2, SSAS 2008R2, SSRS 2008R2, T-SQL, VSS, Windows Sever 2008, SQL Server Management Studio.

Confidential

Network/System Engineer

Responsibilities:

• Managing DC, CITRIX, VMWare and backup services.
• Managed Active Directory User Privileges, Citrix utilities and Backups (Daily, weekly, Monthly) with Symantec backup utilities
• Installed windows 2008 R2 server for File server, webserver, ERP, HR software
• Virtualization with VMware and controlled the full setup with Vsphere
• Worked with office Microsoft azure (office 365), also knowledge of Azure SQL servers
• MS-Exchange Server Administrator”

Confidential

ERP Team Coordinator

Responsibilities:

• Analysing and Coordinating with TDM for Creating Tasks for Programmers & Developers
• Preparing weekly reports on progress of Technical Department
• Maintaining Minutes of Meetings and Customer Interactions in Customer Interaction System (CIS).
• Analysing, tracking and maintaining schedule for projects and reporting the same.
• Assisting the Technical Department Manager in recruitments and hiring process.
• Ensuring that all tasks are going as per schedule and bringing to the attention of the management tasks that have gone overtime and reasons
• Analysing the performance of the technical department in terms of performance and meeting deadlines.
• Assisting TDM in all work that comes along on an ad hoc basis.
• Follow up with daily task completion & over time task reports.
• Preparing weekly variation and monthly variation reports.
• Statistical analysis for all reports and creating Use full MIS for Management.
• Creating and maintaining ISO documentation of Projects.
• Keeping track of all running projects of the company and reporting.

Confidential

System Engineer & MIS Support Officer

Responsibilities:

• Installation and implementation of system with VPN support.
• Installing LAN, monitoring Bank System & Networks.
• Training to Staff on Computerized Banking Transactions.
• Designing a Plate form for Recruitment of New Staff.
• Interviews and Training of new system Engineers.