SUMMARY

• 7+years of experience with more than 3 years inBusiness Intelligence and as Data AnalystinProduction, Development and Staging Environments.
• Experienced in SDLC life cycle forAnalysis, Design, DevelopmentandDeploymentphases of the projects with support of Data - Flow, Process Models, E-R Diagrams.
• Projects spanned across multiple countries and included Insurance, Gaming, Healthcare, Finance, HR, Travel and Logistics applications.
• Experience inBI DevelopmentandDeploymentofSSISpackages from SQL Server, Oracle, Excel, and Access; Working knowledge of SSRS, SSAS, and Tableau.
• Experience in Data Warehouse, ETLs, and backend programming tasks - Stored Procedures, Triggers, CursorsusingSQL Server.
• Experienced in generating of reports through Power Pivot.
• StrongCommunication & Management skills with Excellent Role playing capabilities.
• Aware of Test or Regression Defect/Production warranty/Bug Lifecycle in Quality Center tool.
• Currently holding H1B Visa.

TECHNICAL SKILLS

Databases: Confidential SQL Server, Oracle, Confidential Access

Reporting Tools: MS-Excel, Power Pivot, SSRS

Business Intelligence: Confidential SQL Server Integration Services (SSIS)

Programming Languages: C#.NET, VB.Net, ASP, Javascript, HTML, XML

Operating Systems: Confidential Windows, Unix

Case Tools: IBM Rational Rose

Network Topologies/Tools: Putty, FTP, Load Balancer, Vi

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Programmer Analyst

Responsibilities:

• Acted as Onsite coordinator- Gathering requirements from business, working with Solution Design team to have the details captured in Solution Requirement documents and explaining to Offshore. Coordinated with Testing team for effective functioning of application till code deployment into Production environment.
• Managed the change requests - analysed the requests and performed the feasibility analysis of the solution. Ensured proper functionality of code along with the regular defect finding and fixing.
• Ensured proper updates was mentioned for all defects/bugs in Quality Center with correct status changes of the defects.
• Maintained correct defect status reporting to Release manager from Offshore perspective in daily meetings..
• Consolidated the policies in force against different Lines of Businesses of Confidential - Farmers Auto, Bristol west, Life etc to generate reports. Shared the reports with Client leads.
• Validated inflow data in upstream mainframe files and audited it against the resulting data in database from all interfaces.
• Collaborated with stakeholders to gather information on Agents and Policies, and accordingly scheduled mainframe jobs to load data into production.
• Oversaw test scripts from Offshore development team to match with functional and technical requirements of change requirements to avoid reporting of any defects from Testing team.
• Scheduled tasks in Visual Cron in production server along with setting up of batch and database parameters.
• Managed permissions for user groups in production
• Ensured the correctness of data in staging environments after daily and monthly job runs before data is imported into production.
• Was point of contact for Technical-Architect team tasks at Offshore. Streamlined Tech- Arch activities by maintaining documents for the several processes performed.
• Did frequent Scans of application URLs in Veracode platform.
• Ensured the closure of activities from Offshore maintaining clear communication with regular updates with Development Team, Validation Team and the Onshore.
• Deployed packages, solutions, and scripts in staging environments on request from Development and Testing teams.
• Performed database backup, restoration, creation of indexes, and database management.
• Learned and performed Mainframe commands to analyse, upload and download files in Mainframe.
• Analysed and fixed the Stored Procedures, Calculations, Varicent reports, Inbound and Outbound SSIS packages.

Confidential

Data Analyst

Responsibilities:

• Analysed Confidential Xbox sales and marketing data against its competitors - Nintendo WII, Sony PlayStation, and previous versions of Xbox.
• Visual representation of above Analysis data using Confidential Excel MDS (Master Data Services) and Power Pivot features to generate ad-hoc reports to inform improvements of Confidential ’s competitive positioning. These insights helped drive critical business decisions. Created Pivot Tables and used functions like VLOOKUP and graphs and charts for analyzing related information
• Designed SSIS packages to export and import data to/from SQL server from/to other sources/destinations after processing.
• Wrote SSAS MDX queries to derive insights on Xbox game concentration across different geographical areas in defined Cubes.
• Analysed the outputs displayed to customer through SSRS reports.
• Used COSMOS language to pull Xbox data from various data streams; filtered and processed the data to store in SQL server database.
• In house mega-pivot expert.
• Reviewed & Tested SSIS packages, fixing bugs (if any) using SQL Business Intelligence Development Studio.
• Delivered error free products to client.
• Assisted in proper maintenance of unit test cases scenarios for assigned changed requests.
• Lead the process improvements, quality improvement of deliverables, and root cause analysis and resolution of issues.

Confidential

SSIS and .Net Developer

Responsibilities:

• Coordinate with business leaders, onsite delivery heads and project teams, and offshore project teams for end-to-end delivery of projects.
• Gathered, processed, and documented requirements from client, acted as a bridge between onsite and offshore
• Ensured on-time delivery and high quality of the projects; provided customer support.
• Used UNIX commands to check the file downloaded in a server and the data validity in the file.
• Wrote and reviewed Test Cases for various components with attached evidences based on Requirement Specifications and was appreciated for getting proper approval closure from clients before deploying in Production.
• Was involved in maintaining of Test Plan and Scripts, Test Check List, Requirements Tracebility Matrix, Defect Log, Testing Progress report during Software Testing of my application.
• Designed SSIS batches for migration of data of multiple formats across multiple sources - Oracle/SQL database, flat files, excel, text files.
• Created SSIS batches to handle different type of data formats like Unicode (UTF-8) to non-utf conversion and save accordingly in database.
• Used scripting task in VB for specification of tasks and queries.
• Used other tools like Derived Transformation editor for adding new columns, changing data format, Merging tasks, Conditional operator, Look up task, Merge joins, Sort, Multicast etc in SSIS.
• Recipient of Pat-on-back and Bravo awards for exemplary contribution to the project.

Confidential

SQL Server and .Net Developer

Responsibilities:

• Proposed and implemented enhancements that resulted in 70% reduction in number of erroneous transactions, 30% reduction in turnaround time, and 20% reduction in number of clicks per transaction.
• Exposed to all the phases of SDLC - coordinated with business analysts in requirement gathering and analysis; designed and documented database schema and application flow; developed the application, coordinated in testing, deployment, and user acceptance test. Designed and tested Unit test cases for change requests.
• Provided technical and project specific trainings and seminars to new hires.
• Designed and developed new pages of the application using C#.Net, VB.Net, ASP.Net and ASP.
• Wrote Stored procedures and functions in SQL Server.