• Developed relational databases optimized to provide data to FSA application.
• Worked with clients to address pressing issues by handling requests via internal ticketing system

Responsibility:

• Collaborate with users and management on developing performance metrics
• Establishing system performance metrics and defining mechanism for tracking performance on an ongoing basis
• Determining database environment setting up for applications from development through Integration implementation
• Collecting information to be recorded in database
• Dividing information into tables, turning information into columns and creating table relationships
• Managing the tasks of generating capacity plans for upcoming projects
• Consistently met the project's deadlines for adding table modify column and constraints into the database and implement it integration while working with software developer and client service teams to further improve the product.
• Demonstrated ability to adapt to company's evolving environment by learning quickly & taking on expanded roles by implementing new procedures and improving existing ones.
• Created T-SQL objects & scripts used to maintain data integrity across all databases throughout database servers (Stored Procedures, Triggers, and Functions).
• Capture the Business Overview, Identify the Business Problem
• Joining Daily scrum meeting with JIRA instances for Project Tracking, Test Management, Support Tickets and Agile tracking.
• Coordinate project initiatives with software developers, stakeholders, project managers and software testers Environment: MS SQL Server 2014/2008R2, SSRS, SSIS, SSAS, Visual Paradigm, JIRA, MS Office, Windows 7.

• OTTO is a vertically integrated manufacturer with in-house injection molding, stamping, CNC machining, cable assembly and cable over-molding capabilities.
• I was involved support and maintenance of the existing reports for manufacture, providing development and testing support for the new reports, creates new reporting solutions for the data warehouse as required.

Responsibilities:

• Expertise in performance tuning of T-SQL queries and Stored Procedures.
• Worked with Excel Power Pivot reports and Pivot charts for analyzing the data from various systems for business needs.
• Collaborated with Integration of different systems involved in the business flow and building reports on top of it for analysis purpose and Involved in manual data validation after ETL runs.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server and Implemented error handling and rollback process in ETL load.
• Used expressions and variables in SSIS to make load dynamic.
• Design, deployment, and maintenance of many SSRS Reports in SQL Server 2008R2.
• Generated various reports with drill down, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Worked with control flow and workflow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Developed many OLAP cubes from scratch according to business needs in SSAS.
• Involved in the documentation of production deployment.
• Scheduling SQL Server Agent jobs for daily and weekly basis. Environment: MS SQL Server 2012/2008R2, SSRS, SSIS, SSAS, Visual Studio.Net 2010, VB.NET, C# 3.5, MS Office, Windows 7.

• The project involved designing a new database schema and migrating databases to the Production environment, modifying database structures, providing support and guidance to operational models by checking for data quality and its consistency.

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis.
• Provide database coding to support business applications using T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensured applied, and integrity of data maintained through security, documentation, and change management. Tools & Technologies: MS SQL Server 2008, T-SQL, Win 2003 Advanced Server, Erwin v7.2.

• FinEngine supports the functions of business analysis, trading analytics, cost analyze and on demand analysis for client side.
• The project involved migrate data into 2008 to 2012 SQL Server and also working with ETL process using SSIS tools transform data to the data warehouse.
• Finally, the project gives more power to the analytical strategist, management and end users enabling them to build their analysis and equip themselves with Ad hoc and OLAP reporting tools.

Responsibilities:

• Performed by following the normalization standards appropriate changes from SQL Server 2005 to SQL Server 2008 to maintain data consistency and data validation.
• Actively participated in gathering Business Requirements Analyzed the Business Requirements, System Specification and implementing the logical design and physical design.
• Creating SSIS Packages by using advanced transformations (PowerPivot Transformation, Derived Columns, Fuzzy Lookup, Term extraction, Condition Split, Aggregate) and also used Custom components such as Audit on Pre-Execute, Audit On Post-Execute, Custom Email Task and Statistics Logging Component.
• Performed create a dynamic SSIS packages using complex expressions, variables and also control flow components such as For Each Loop, container and For Loop to loop over a Directory to load inbound files.
• Applied the Business Rules and the requirement to filter bad data from the system by using Complex T-SQL Statements and implemented in various Constraints and Triggers for Data Consistency.
• Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages
• Responsible for creating the reports based on the requirements using SSRS 2008.
• Wrote a query for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Created a different type of reports which include: Cross-tab, Conditional, Drill-down, Sub report, Parameterized report and deployed scheduled Reports in Report Manager using SSRS generating all daily, weekly, monthly and quarterly Reports.
• Monitoring performance and optimizing SQL queries for maximum efficiency
• Modified the existing SSIS packages to meet the changes specified by the users.

Tools & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Business Object 3.1, Oracle 11g, Microsoft Excel